Text box value validation

  • Thread starter Thread starter George Papadopoulos
  • Start date Start date
G

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
 
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
 
Also check out the Form_Error event. This provides a more generalized method
of replacing Access error messages with your own ones.

HTH,
TC
 
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
 
From memory, the Response parameter to the Form_Error event procedure lets
you return a value to say, "do not display the normal error message". I
don't have Access here to check. It should be clear from online help.

Cheers,
TC
 
thx, for your help!


Ï "TC said:
From memory, the Response parameter to the Form_Error event procedure lets
you return a value to say, "do not display the normal error message". I
don't have Access here to check. It should be clear from online help.

Cheers,
TC


that
Click to expand...
 
Back
Top