Format Date

  • Thread starter Thread starter Ginny
  • Start date Start date
G

Ginny

I need to format my date in mm/dd/yyyy. When I use the
imput mask wizard to format the date it displays as
1 /9 /2004. How do I display the zero where needed?
 
Check Access Help on the InputMask Property and the Format
Property. They are 2 different Properties controlling how
your data is entered and displayed.

It sounds like you got mixed up between the 2 Properties.
I think you should set the Format Property to "MM/DD/yyyy".

HTH
Van T. Dinh
MVP (Access)
 
Back
Top