I found the bit in Control Panel that changes the system default from
yyyy/mm/dd. Now I'm happy with it. Thanks for pointing me that way.
Jerome.
On Dec 2, 12:40 pm, "Douglas J. Steele"
<NOSPAM_djsteele@[EMAIL PROTECTED]
> wrote:
> Access gets its format from the operating system's Short Date format,
which
> is set through Regional Settings in the Control Panel. While you say
that
> your international settings on the Vista compure are "for the US", have
you
> confirmed the Short Date format?
>
> For what it's worth, it doesn't matter. Format only affects how the
data's
> displayed, not how it's stored. Internally, dates are eight byte
floating
> point numbers, where the integer ****tion represents the date as the
number
> of days relative to 30 Dec, 1899 and the decimal ****tion represents the
time
> as a fraction of a day.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "rocketeer" <java...@[EMAIL PROTECTED]
> wrote in message
>
>
news:e810fbe1-ae75-446f-b6cb-087931a2d7ef@[EMAIL PROTECTED]
>
> >I have a database that I copy between an XP computer and a Vista
> > computer. When I show records in XP, date/time fields display like
> > this: 12/02/2008. When I show records in Vista, they display like
> > this: 2008/12/02.
>
> > I've looked at my international settings on the Vista computer and it
> > is for the US. I looked throughout the Access setup and it doesn't
> > give me control over forwards/backwards.
>
> > What am I missing here?
>
> > Thanks,
> > Jerome.
|
