Create an input mask

In a Microsoft Access project, you can create an input mask in a table, query, or form.

Create an input mask for a field in table Design view

1. Open the table in Table Designer or the query in Query Designer.
2. Click the Columns tab in the Table Designer, or right click the in the Query Designer, click Properties, and then click the Columns tab.
3. Do one of the following:
   • Click the Build button next to the Input Mask property to start the Input Mask Wizard, and then follow the instructions in the wizard dialog boxes.
   • Type the input mask definition in the Input Mask property field.

Create an input mask for a control on a form

1. Open a form in Design view.
2. Select a text box or a combo box, and then click Properties on the toolbar to open the control's property sheet.
3. In the Input Mask property box, do one of the following:
   • Click the Build button in the Input Mask property box to start the Input Mask Wizard, and then follow the instructions in the wizard dialog boxes.
   • Type the input mask definition in the Input Mask property field.