Create an error on Illogical (Silly) dates!?

[gangel]

Hey everyone,

So I have some date boxes and i want the input to msgbox if the date is 'illogical'

Note: I'm in Australia and using dd/mm/yy

In saying illogical I mean if i write 92/5/14 I want it to know this is an impossible date (there is no 92/5/14 by aus standards) but instead it converts it to yy/m/dd.

I know it is being smart... but i want it to be dumb and know that if the numbers are stupid then perhaps it is a mis-entered value rather than someone wanting to enter dates in American dating system..


i was thinking testing for format(X,"dd/mm/yy") but I don't really know how to go about it..?

Regards,
Gangel

[June7]

Might have to input date parts into individual text or combo boxes.

Have you read this article by Allen Browne (another Australian) http://allenbrowne.com/ser-36.html

[gangel]

will read now,. I actually might try to catch up this guy, we're in the same city and he seems big in the access crowd!

[June7]

Except he's retired from Access, doesn't take clients anymore, no idea if he would be willing to talk. http://allenbrowne.com/tips.html

[Missinglinq]

You're using Access 2010, which has a native DatePicker for Date/Time Fields...is there a reason why you can't simply limit input to the DatePicker, thus assuring that it is a valid date?

Linq ;0)>