Create an input mask to control how data is entered in a field or control

Create an input mask to control how data is entered in a field or control

You can use the InputMask property to control how data is entered in a field in a table or query, or in a control on a form or a report.

What do you want to do?

Define an input mask for a field in table Design view

Define an input mask for a field in query Design view

Define an input mask for a text box or combo box in form Design view

Not sure which choice you want?