How do I use input masks with date fields?

A

austinbeatle

I am using Access 2003.

I want to create an input mask on a form for a date. All entries will be in
a single digit month of 2007. Therefore, I would like the prefills in the
field to be the zero before the month and the year - like this: 0_/_ _/2007.
That way the user only needs to fill in the one digit for the month and the
two digits for the day.

1 - How do I code this in the input mask property field?
2 - Do I need to program any other property fields to make this work?
3 - Once it works, how can I apply this change to all date fields so I don't
have to go back and change every date field?
 

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