stickleprojects Level: Moderator

 Registered: 09-09-2002 Posts: 1060
|
Re: Change date format...
Hi
You are experiencing the wonders of MSAccess in US style. This is the default display and read format for Access and cannot directly be changed.
What you can do, tho, is change the data where it is displayed (on form or report).
To do so:
Select the control, then view properties, and change output format to Short Date - this will pick up your windows settings.
Note: In my experience Windows settings are generally only used by ADO command objects and not by access when searching for fields in queries. I am sure that if you have a non-english locale (ie. German) you can use US dates still or DEU Dates, so I think the rule is access assumes all dates are in US format, unless it cannot , then it uses the windows locale.
To test:
search for 11/12/2008 in a uk-english locale, and you'll see Nov 12 2008 records (not, dec 11 2008)
Hope this helps,
Kieron
____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)
|