Access Date Validation

  • Thread starter Thread starter carriolan
  • Start date Start date
C

carriolan

Hi
I have a very simple problem indeed, but I am unable to solve it. I
am inputing a short date into an unbound text box with a short date
input mask. I am in the UK so my date format is dd/mm/yyyy. Everything
works superbly well with one exception.
Example: Suppose I accidentally keyed in 04/13/2005 the program
assumes that I meant 13/04/2005 and swaps the day and the month field
around without displaying an error, so the date is incorrectly
processed as 13/04/2005. How do I stop this please?

Regards
Carriolan
 
Hi
I found auto correct was set to 'yes'. Now this gets me part way
there. It prevents the date from being switched around, but it still
does not trap the error 04/15/2005. This is really strange as I am
using a default date of today which comes up in dd/mm/yyyy format. It
appears to allow both dd/mm/yyyy and mm/dd/yyyy formats - how do I
stop this please?

Regards
CarriolanOn Sun, 04 Dec 2005 22:40:22 GMT, "(e-mail address removed)"
 
Unfortunately, you can't.

When you enter a date that's not valid, Access (and other MS products) tries
to be helpful and find another format that can be used to accept your input.
 
Hi
Thanks for that. It looks as though that my only hope is a date picker
then
Regards,
Carriolan
 
Back
Top