Date formatting problem 1

[tonyireland]

I have a form in my Access Runtime application which accepts three dates.
They all use an input mask of 00/00/00;0;_ and a format of short date. This works perfectly well on loads of PCS running a mind boggling variety of different set ups. However on one PC running Windows 2000 with short date set to dd/MM/yyyy on entering the date of 14/11/03 the dates are formatted as 03/11/2014 and one of the dates when entering 07/11/03 appears in US format as 11/07/2003. You can probably imagine what the user said when I suggested it might be a Windows problem! Has anyone ever experienced anything like this? I've found nothing on the Microsoft website.

thanks

TonyIreland

 

[Eupher]

Rather than specifying "short date" as the format and then being subject to the whims of the OS or other gremlins, you could force short date format (or any other format of your choosing), i.e. "mm/dd/yy".

HTH...

Ken S.

 

[tonyireland]

That's the solution, thanks very much Ken, I am changing all my forms as we speak.
What had happened was that although the regional settings in control panel showed the short date format as dd/MM/yyyy when I looked at the register setting

HKEY_CURRENT_USER\Control Panel\International\idate it was set to zero which is the US format.