Error on date

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi I have a date input mask and I get an error message
saying that the format is wrong if for example one number
is left out of the year etc..

please could you tell me how to trap this error to
display my own error message, I must have it as a
vbinformation msgbox instead.

Thanks

Peter
 
Hi Peter,

What does the mask look like now? And what do you want it to do for you? Are
you asking if it is possible to have a date input mask that allows you to
enter a date as say '3/21/05' and have it stored and displayed by Access as
'03/21/2005'? Or do you really want to catch the error and force the user to
do things as expected (i.e., enter the date as '03/21/2005')?
 
Back
Top