Is there any way to make Access overrife the computer regional settings for
date formats. I am having problems with mdbs using Canadian date formats
DD/MM/YYYY when installed on systems that have US date formats in regional
settings MM/DD/YYYY. A lot of Canadians it seems simply leave the US
defaults on preinstalled Windows and it causes dates to be screwed up.

Any help appreciated.

Thank you.

Ray

Ray, take a look at:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
It discusses the 3 cases where Access is likely to misunderstand our d/m/y
date settings.

IMHO, an Access developer has no right modifying the user's formats,
particularly formats that apply to other software as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ray" <(E-Mail Removed)> wrote in message
news:FEA14AD6-2F8C-4033-9D07-(E-Mail Removed)...
> Is there any way to make Access overrife the computer regional settings
> for
> date formats. I am having problems with mdbs using Canadian date formats
> DD/MM/YYYY when installed on systems that have US date formats in regional
> settings MM/DD/YYYY. A lot of Canadians it seems simply leave the US
> defaults on preinstalled Windows and it causes dates to be screwed up.
>
> Any help appreciated.
>
> Thank you.
>
> Ray

Format(DateVariable, "formatstring")

HTH
--
-Larry-
--

"Ray" <(E-Mail Removed)> wrote in message
news:FEA14AD6-2F8C-4033-9D07-(E-Mail Removed)...
> Is there any way to make Access overrife the computer regional
settings for
> date formats. I am having problems with mdbs using Canadian date
formats
> DD/MM/YYYY when installed on systems that have US date formats in
regional
> settings MM/DD/YYYY. A lot of Canadians it seems simply leave the
US
> defaults on preinstalled Windows and it causes dates to be screwed
up.
>
> Any help appreciated.
>
> Thank you.
>
> Ray