month/day/year

[noe1818 via AccessMonster.com]

I want to be able to enter the month, then the day, then the year. Access
decides to display my month as my day, and my day as my month. How can I
change it to display what I want it to display?
Ex. 01/09/08 = sept 1, 2008. It should be Jan 9, 2008

N.B. I live in Canada and we write month/day/yr, so I need to be able to
enter and display it this way.
Thanks

 

[noe1818 via AccessMonster.com]

I found out how to change it, if anyone wants to know in the future. I had to
go into control panel and change how my regional settings. In short date, I
changed it from dd/M/yy to M/dd/yy. That way when I typed my month first it
would stay there.
If anyone finds out how to change it only in access, please let me know. I
would hate to have to change it for all the computers in the office.
Thanks.
-Noe

 

[Klatuu]

You found the correct way to do it. It can't be done just in Access.

 

[Douglas J. Steele]

<picky>
Yes it can be done from Access, but it takes API calls.

Check my September, 2003 "Access Answers" column in Pinnacle Publication's
"Smart Access". You can download the column (and sample database) for free
at http://www.accessmvp.com/DJSteele/SmartAccess.html

That having been said, here's my comment from the module where I show how to
do it:

' It's with a fair bit of trepidation that I include the routines in this
' module. One part of my reluctance is because it's really outside
' of the scope of these examples to explain exactly how these API
' calls work, but the bigger reason is because I do not believe that
' programmers have the right to change User settings. Your users
' have presumably made specific choices for how they want to work
' with their computer, and I feel it's our duty as programmers to respect
' their choices. I often hear the argument that "But they're using my
' application, and so I should be able to control how it works."
' While that may be true, remember that odds are that your application
' isn't the only application with which they're going to be working.

</picky>

 

[Klatuu]

I am aware of the API in your article, but based on your stated philosophy
(with which I wholeheartedly agree), I believe some things are better left
unsaid.