validation rule in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I set the validation rule to "is not null" for a combo box on a form
I set the default value to null
When I left the field blank, Access didn't complain
why is this?
 
I set the validation rule to "is not null" for a combo box on a form.
I set the default value to null.
When I left the field blank, Access didn't complain.
why is this?
Click to expand...
The validation only triggers when there is a change. If you are just
leaving it "blank" your'e not changing it.

Use the Form's BeforeUpdate event to check for this.

- Jim
 
Back
Top