Input Masks - tabbing into control

[GaryRW]

I have discovered a strange thing with my database today.

I have input mask "09/09/0099" in text boxes linked to date fields. This works fine. (btw, I'm in the UK since we're talking about dates).

I have come across a problem with regional settings. If the regional settings do not match the above format, e.g. if they are set as dd/mm/yy instead of dd/mm/yyyy, then a very annoying thing happens. When you tab into the control, the input mask does not display, and then when you try and enter a perfectly valid date, it says not valid for this input mask. If you click on the control, the input mask displays (e.g. "__/__/____" and everything is fine and the date is accepted.

Any ideas how to get round this. I don't want to resort to telling every user that they have to have the same regional settings. Any help would be V gratefully received

 

[Garridon]

Bet you have 2002. For that, it looks like Access went to a four digit year, and for some reason, it doesn't like the two digit year input masks. The way I fixed it was to redo the input mask on the forms with the problems. Once I did this, it worked fine.

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[GaryRW]

Thanks Garridon,

Do you mean Access 2002 - if so, I'm sorry to disappoint but I'm still on Access 2000.

How did you change the input masks anyway? from 00/00/00 to 00/00/0000?