var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date formatting -- Quick Question
The company I work for just upgraded their version of Access from 97 to 2002.
In the 97 version of Access if you hit Ctrl + ; the current date would automatically be entered in mm/dd/yy format. But now in the new version, it will enter the date in mm/dd/yyyy format.
This is causing many problems. Could someone please inform me as to how I would go about changing the format the the old style?
Thanks in advance!
I believe this has something to do with the regional settings on the desktop pc's themselves
make sure that the control is formatted for shortdate and the input mask forces the 2 digit year.
Also check at the table level as well
check the regional settings of the pc and set the format for the 2 digit year as well
i hope this works - i have had this problem before and it seemed to fix it for excel cells but not all of my access apps
Yep. It's fixed now... it was the regional settings...