Error Message and Date Validation Questions

[cpsqlrwn]

I have a date field that has validation rules and mask properties. In my form violation of these properties produces the generic Access error messages. How do I eliminate those messages from displaying so that I can have only my messages appear? Also, what code would be used to insure that a date field with no validation rules or mask contains a valid date?
Thanks for any help!!

 

[PHV]

1) Have a look at the Error event procedure of the Form object.
2) Have a look at the IsDate VBA function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cpsqlrwn]

Thanks PHV! I'll check it out and get back.