Date Format Input Mask

[Guest]

Hello,


I have a text box who's date format I would like to be able to input as
MM/DD/YYYY such as in "04/15/2006". Access does not appear to offer that
format from the Format drop-down menu. All the dates appear as DD/MM/YYYY.

How can I setup my textbox to accept date entries in the "MM/DD/YYYY" format.

-A

 

[Al Camp]

Alias,
The ShortDate format is...
mm/dd/yyyy
If you don't show that, check your Regional and Language Options in Control Panel to
see if your ShortDate is set up for...
M/d/yyyy

 

[Guest]

Al,

My Regional settings are as follows:

Short Date: 15/04/2006
Long Date: Saturday, April 15, 2006

The short date format is dd/mm/yyyy instead of mm/dd/yyyy.

What must I do to get the date to read in the "mm/dd/yyyy" format in Access?

-A

 

[Guest]

Al,

Thanks a lot. I was able to change the date format in the Regional Settings
and now the date appears correctly in Access.

My concern now though is the date format will be dictated by the users
Regional Settings. Is there a way to force a date format of mm/dd/yy in
access that's not affected by Regional settings?

-A

 

[Al Camp]

I wouldn't get too concerened about it. Your regional setting was not the "norm", or
was changed in the past. I would think Windows comes with standard US Short date format
of m/d/yyyy.

 

[John Vinson]

I would think Windows comes with standard US Short date format
of m/d/yyyy.

Depends entirely on where you buy Windows! It's localized to the
country of distribution.

John W. Vinson[MVP]