Access Date Validation

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

 

[Douglas J. Steele]

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.

 

[carriolan]

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

 

[Douglas J Steele]

A great one that's easy to work with is what Stephen Lebans has at
http://www.lebans.com/monthcalendar.htm

For other alternatives, see the list Jeff Conrad has at
http://home.bendbroadband.com/conradsystems/accessjunkie/calendars.html

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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

input.