Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I enter data format dd/mm/yy instead of mm/dd/yy in Access 200

Status
Not open for further replies.

acin0026

Technical User
Feb 5, 2001
12
TH
My country use Date format dd/mm/yy but default in Microsoft Access use format mm/dd/yy. I want to let user enter data format dd/mm/yy. I already changed Date format in Regional Settings in Control Panel to dd/mm/yy. When I enters Date which day more than 12, It shows correct Date (dd/mm/yy format). However, it changes to mm/dd/yy format, if I enters Date which day less than 12.

Example
I enters I want It shows
15/01/45 15 Jan 2545 15 Jan 2545
02/01/45 02 Jan 2545 01 Feb 2545
05/03/45 05 Mar 2545 03 May 2545

Thanks
 
If you are using a table, in design view choose the field name and then change its Format property to dd/mm/yy, then change the input mask as appropriate, If you are trying to do this through a form then do the same aunder the controls Format tab (i.e. don't use any of the settings in the drop down menu type your own as dd/mm/yy.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top