Date Format on FORM

[Bill]

Hi,

I want to know if there is a way to set a code for Date format into
DD-MM-YYYY. Right now, I have the date on the form showing DD-MM-YY. I am
trying to figure it out how to set on the form instead of TABLE.

I try to use table but I couldn't figure it out how to set DD-MM-YYYY.
I am looking how to set date format on the FORM instead of Table.

You help would be much appreciated.

 

[Allen Browne]

The best way to do this is to use the Windows Control Panel | Regional
Options to define Short Date as dd/mm/yyyy. Access will then use this as the
default date format anywhere in the interface: tables, queries, forms, and
reports (but not in VBA code or SQL strings).

You can set the Format property of any text box on a form. However, if you
use the Control Panel, the dates still work for someone else who has a
different date format than you.

There is also an option under Tools | Options | General to force Access to
display dates using 4-digit years. However, this setting is useless, as it
overrides the Format property of a text box, so if you did need for show a
2-digit year somewhere (such as a credit card expiry date), you can't.