data validation in new records

D

Dan

This must be very basic, but this is my first Access project. Why is data validation not performed on a new (tentitive) record? If I edit an exisitng record the validation, such as REQUIRED is enforced as soon as I exit the field. But when appending a new record I can tab around the record (either in table view or form view) and the rule is not enforced until I save the record. The logical place to enforce data validation is when entering new data in a field. What am I missing?
 
J

Jeff Boyce

Dan

If you wish to test each control as you exit it, you'll need to add your
testing code to the AfterUpdate event of each control.
 
Top