validation rule in form

[Desert Bear]

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?

 

[Jim Allensworth]

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?

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