Data Validation only works if I enter a value

[SteveSydney]

I have a field on a form that has a data validation rule.

This only works, if I actually enter a value.



Why?

Eq I test for the field to be greater than 5.

The first time I enter 1 to 4, it gives me an error, then if I tab out of the field again, it ignores the error?

Is this normal?

[June7]

Doesn't ignore for me. In fact, if I delete the entry, validation fails because of Null.

Post the validation rule expression.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Missinglinq]

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)>