Month and Day value reverse

[tis9700]

I've never seen this happen before...

I have a textbox on an unbound form for entering a Date of Birth. It has an input mask and the format is short date.
mm/dd/yyyy

But when I type in 13/10/1978, I'm trying to purposely enter a bad date, the month reverses automatically with the day to give 10/13/1978.

Is this something simple and I've overlooked it? Why is this happening?

 

[ProgramError]

Take a look at the format function or check you local settings are not incorrectly set. I found this occurred when I linked to a ODBC back end and the field was only a date field and not a date time field.

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[tis9700]

Hi ProgramError,

My local settings were correct and it has something to do with the format function...

Check this out about Access misinterpreting dates

From Allen Browne

http://allenbrowne.com/ser-36.html#Interface

All I can say is... WAHHHHH!!!