Help Access Date Validation is drivig me to drink!

[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

 

[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:38:59 GMT, "(e-mail address removed)"

 

[Marshall Barton]

Gee, AFAIK, you can't stop it. Access is, IMO, too
forgiving in allowing anything it can contort into a legal
date. It does try to use your date settings first, but if
that isn't a legal date, it keeps trying until it can
convert it to one.

I guess you could write your own date parsing procedure to
do your own conversion, but I doubt it would be worth the
effort and may not allow some user to enter a perfectly
legal date (e.g. 15 April 05 or 2005-4-15 or 15 Apr or ...)

 

[David C. Holley]

Please only post in 1 NEWSGROUP.

 

[carriolan]

Hi
Yes, I have already been admonished on another news group. 6 Hours of
trying and panic set in!
Regards
Carriolan

 

[carriolan]

Hi
Thanks for that. It looks as though that my only hope is a date picker
then
Regards,
Carriolan