By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,711 Members | 1,320 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,711 IT Pros & Developers. It's quick & easy.

Differences in Access Date formatting on different machines

P: n/a
Hi, I run Access 2002 SP3. I have rolled out a FE database to
different machines. On one particular machine the date format settings
are different in Access.
Does anyone know how to change this? I have checked the Regional
settings in control panel and everything is the same
Regards

Jun 6 '07 #1
Share this Question
Share on Google+
2 Replies

P: n/a
KayC wrote:
Hi, I run Access 2002 SP3. I have rolled out a FE database to
different machines. On one particular machine the date format settings
are different in Access.
Does anyone know how to change this? I have checked the Regional
settings in control panel and everything is the same
Regards
When an explicit format has not been set then Access should use the regional
settings. Regardless of that though anytime you care about the formats you
should NOT used named formats "Short Date", "General Date", etc., but rather
should use an explicit format property string like "mmm-dd-yyyy". That is
the only way to guarantee that all machines will display them the same.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jun 6 '07 #2

P: n/a
Rick - looks like I have the formats you formerly mentioned - thanks
for the tip

Rick Brandt wrote:
KayC wrote:
Hi, I run Access 2002 SP3. I have rolled out a FE database to
different machines. On one particular machine the date format settings
are different in Access.
Does anyone know how to change this? I have checked the Regional
settings in control panel and everything is the same
Regards

When an explicit format has not been set then Access should use the regional
settings. Regardless of that though anytime you care about the formats you
should NOT used named formats "Short Date", "General Date", etc., but rather
should use an explicit format property string like "mmm-dd-yyyy". That is
the only way to guarantee that all machines will display them the same.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jun 6 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.