Format 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?
 
V

Van T. Dinh

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)
 
Top