Differences in Access Date formatting on different machines

[KayC]

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

[Rick Brandt]

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

[KayC]

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