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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top