Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access XP - Month/Day switch places???

Status
Not open for further replies.

tallbarb

Instructor
Mar 19, 2002
90
US
I was keying in an invalid date (14/8/2005) on an Access table and, when I pressed <Tab>, Access changed the date to 8/14/2005. I was tyring to show someone the error message you get with an invalid date - well, I didn't expect it to swap the month/day! Why does it do that and how can I stop it from happening?
 
Access is just being helpful. This is one of the "features" that I don't think you can turn off in Access.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top