Date Format on FORM

  • Thread starter Thread starter Bill
  • Start date Start date
B

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.
 
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.
 
Back
Top