Validation Text

[johndoh!!]

I have a few fields that are required in thier tables and have set the "Validation Rule" and "Validation Text". When i use a form that has these fields in them and break the "Validation Rule" i am getting the Access error message not my "Validation Text".

I have gone so far as to enter the same rule and text into the form field properties and yet no luck. I seem stuck with MS's error messages no matter what i do.

Any ideas on where to look for this or what i may have done wrong would be greatly appreciated!!

D'oh

 

[Jack Cowley]

Do your validation in the Forms or Fields Before Update event. Then you can pop up your own messages and determine how to handle the missing or incorrect data. Access help has sample code that shows you how to do this.

hth,
Jack