Originally Posted by
SteveSydney
I have a field on a form that has a data validation rule.
This only works, if I actually enter a value.
Why?
If you don't enter data into it...what does it have to validate?
If you want to validate the data and insure that the Field is populated, you need to do the validation and make it required, either in the Table Def or in the Form_BeforeUpdate event.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007