Validation Rules

[Tony Williams]

I am trying to create a validation rule to check that a text box control is
not blank when the record is saved. I have used Is Not Rule in the
Validation Property of the control but it doesn't work. I've read the Help
on this but I don't see how just using Is Not Null in this property should
work??
What am I missing?
Tony Williams

 

[Rick Brandt]

I am trying to create a validation rule to check that a text box control is
not blank when the record is saved. I have used Is Not Rule in the
Validation Property of the control but it doesn't work. I've read the Help
on this but I don't see how just using Is Not Null in this property should
work??
What am I missing?
Tony Williams

A validation rule for a control on a form is only enforced if the user actually
enters something in that control. I believe a *table-level* validation rule
applied to the table itself (not the field) would work. Alternatively, you
could use the BeforeUpdate event of the form to test that the box was checked
and then set Cancel = True and display a message when it is not.