Date field not stay in same format

K

Kyle

I have a Due Date field in my form. I noticed the date not stay in the
format I want dd/mm/yyyy. it keep change back to mm/dd/yyyy when user enter
22/03/2008 ==> 03/22/2008. How do I make the date stay as dd/mm/yyyy. As
long as the day is below 12, then the format stay as 12/03/2008 (dd/mm/yyyy).

Any help to correct this problem is appreciated.

Thanks.
 
A

Allen Browne

Access displays dates in the format you specified for your regional
settings. Go to Regional Options in the Windows Control Panel to define your
date format.

For details, see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

If you have entered the dates thinking one thing, but Access interpreted
them as something different, you may need to go back and correct these
entries.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing a date entry format of dd/mm/yyyy 1
displaying dates in UK format 10
Default Date in forms... 5
MM/YYYY Input format 2
convert date 1
Date calculations - please tell me where I am going wrong 2
Combo box date format changes when item selected from list 4
Format a Date Text Box As 2010-02-28 3

Top