Text box value validation

[George Papadopoulos]

Hello everybody

I have a form with a text box on it. The text box is bounded to a date
field of a table. Thus, I have set the format of the text box to date and
set an appropriate input mask.
The problem I have is that when a user inputs something other that a date
Access displays some cryptic, to users, error messages. I would like to
display an error message of my own.

Can I do that?

George Papadopoulos

 

[Nikos Yannacopoulos]

George,

While in form design view, select the text box and display properties, tab
Data. Set your Validation Rule, and then use the Validation Text property to
enter your own message to be displayed when the validation rule is not met.

HTH,
Nikos

 

[TC]

Also check out the Form_Error event. This provides a more generalized method
of replacing Access error messages with your own ones.

HTH,
TC

 

[George Papadopoulos]

ok. I now can display my own error message from within the Form`s generic
error handler. But Access still goes on printing it`s own error messages.
Can I avoid that?

George