Validating Access [Resolved by Rob]

[Danial]

Hi,
I am helping my sister with one of her college project and try to stay away from VBA. Anyhow just need some information regarding VBA in access. I have put validation in the Datbase Itself using validation rules. Now the validation works fine if I input the data directly into table. If I enter data using Forms then I am presented with a Error message saying You Can not perform this action, instead of the Error Message I set up in the Validation Rule.

I would prefer not to do the validation in the form and keep it into the Database itself. Is that possible in Access? If so how would I get that error msg defined for a particular field?

Also I have managed to setup most of the validation apart from checking for Empty value (NULL) that dont seem to work. How do i set a validation rule so User must enter something for that field.

Cheers for your help.

Danial