- Open the table in Table Designer or the query in Query Designer.
- Click the Columns tab in the Table Designer, or right click the in the Query Designer, click Properties, and then click the Columns tab.
- 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
- Open a form in Design view.
- Select a text box or a combo box, and then click Properties on the toolbar to open the control's property sheet.
- 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.