Ray- I checked: Allow Edits: Yes Allow Deletions: Yes Allow Additions: Yes Data Entry: <blank> I learned something!! I thought it was *either* Yes or No!!! I did not know it could be blank!! I changed this to "Yes" but upon exiting, rebooting, etc. then reopening Access it is <blank> again. I think you hit it again. But now the question is: Why does it go from "Yes" to <blank> again? What have I done or botched to do? Tab order is ordered the way I ordered it for speed; i.e., the next field is also the next piece of information I have on paper. The color changing inquiry- Blame client. <g> Her request was "If everything is ok, I don't want them to see anything there. If there is a problem, make it jump at them." The background is gray. So I thought, well, gray if nothing there, white characters on red background if there is an alert. Thank you! Robert -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of Ray Blake Sent: Wednesday, May 04, 2005 1:44 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Conditional Format skips filed in Access 2000? Some things to check: 1. Look at the field properties before entry, after entry and once you've removed an entry - particularly the 'can edit' and 'enabled' and 'tab stop' properties - are they changing? 2. Check the tab order on the form. If all your conditional formatting is doing is changing the colour properties, this should not lead to a diabling of the control, which seems to be what you're describing. I'm curious as to why you change the text colour to grey in conditions when there will never be text to display - why not just leave it white? ------------------------------------ GR Business Process Solutions Ray Blake Head of Software Design ray@xxxxxxxxx Braedon Newell Road Hemel Hempstead Herts HP3 9PD tel: 01442 396518 fax: 01442 389353 mobile: 07834 226601 www.grbps.com ------------------------------------ -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Carneal Sent: 04 May 2005 03:36 To: mso@xxxxxxxxxxxxx Subject: [mso] Conditional Format skips filed in Access 2000? If I conditionally format a field to match its background with empty, and change to a red background with white bold characters, it works the first time. Assume I have a field called "Alert" and conditional format it this way: 1. If empty, gray background, gray lettering 2. If not empty, red background, white characters I can type in something, and it sticks. It displays as white on red. Now here is the problem: If I erase the contents of the field, save it, open it later and try to tab to that field, it skips it. Thinking the conditional format was the cause of it, I removed the conditional format. The field is still being skipped in the Form. I would like to be able to get to that field via tabbing *with* conditional format, but Access isn't behaving that way. My book doesn't seem to address this. Is this anything anyone has heard of before? Thank you. Robert ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************