Mandatory Fields

[Guest]

I have a table that has a mandatory field called "Date" - I have the
properties of the field set to Required - Yes. When I try to enter directly
into the table or query - it prompts me when I try to exit that the field is
not filled in. When I try to enter in using a form based on the query - it
does not prompt me that the required field is not filled in. What am I
missing?

 

[Allen Browne]

Try changing the name of the field.

Date is a required word in VBA, so the form may think that Date already has
a value (i.e. today's system date).

Unfortunately, it will be a bit of work, but worth the effort.

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
If you don't do this, Access may remember the old name, and the problem may
persist. There are well over a dozen other bugs associated with this
mis-feature anyway, e.g.:
http://allenbrowne.com/bug-03.html

2. Compact the database:
Tools | Database Utilities | Compact

3. Open the form in design view, and change the Name and Control Source of
this text box. Repeat for any other forms, reports, and queries that use
this field.

4. Compact again.