Date formating is diferent on every PC

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jimg3 - 08 Dec 2005 01:10 GMT

I have 3 pc's looking at the same database stored on a server PC. 2 run win98
and 1 runs xp pro. I have set the table field to short date and the form
fields to short date but when you open a form the xp PC shows 01/08/2006 and
1 98 pc shows 01/08/06 and the other 98 pc shows 08/01/06.Is there a pc
setting or access setting that I am missing. Please help.

Reply to this Message

Rick Brandt - 08 Dec 2005 01:59 GMT

> I have 3 pc's looking at the same database stored on a server PC. 2
> run win98 and 1 runs xp pro. I have set the table field to short date
> and the form fields to short date but when you open a form the xp PC
> shows 01/08/2006 and 1 98 pc shows 01/08/06 and the other 98 pc shows
> 08/01/06.Is there a pc setting or access setting that I am missing.
> Please help.

The named formats (short, long, medium) honor the regional settings on each PC.
If you want a consistent format across PCs then don't use the named formats.
Use explicit format strings like "mm-dd-yyyy".

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message