Date format dd-mm-yyyy issue

[paulsps]

Issue:
In the W2000 citrix server regional settings, the short-date format is set to dd-MM-yyyy.
This is what I want.
However, if a date is entered in a (non-bound)textfield with the format 99/99/0000;0;_ , then the date is shown AFTER update of the underlaying table as mm-dd-yyyy.
Access understands, that if I type 30-01-2003, the 30 must be the day, and therefore the date remains correct after saving the record.
But if the first part of the date is < 13, then the day and month will be reversed!

Extra info: The frontend is running on a Windows 2000 citrix server, and the backend on a W2000 fileserver.

I have tried all kind of formatting and so on, but no results..

 

[Golom]

Internally, Access uses US date format (i.e. mm/dd/yyyy) regardless of locale settings. If you are searching or updating an Access database then you must convert to that format or use a date format that cannot be misinterpreted such as dd-mmm-yyyy.