- Open a table in Design view.
- In the upper portion of the window, click the field you want to define an input mask for.
- In the lower portion of the window, do one of the following:
Click the Build button
next to the InputMask property box to start the Input Mask Wizard, and then follow the instructions in the wizard dialog boxes.Type the input mask definition. For more information on defining the input mask, click the InputMask property box and press F1. You must type the input mask definition manually for Number and Currency fields.
Create an input mask for a field in query Design view
- Open a query in Design view.
- In the query design grid, place the insertion point in the column for the field you want to change. You can place the insertion point in any row for that field.
- Click Properties
on the toolbar to open the property sheet for that field. - On the General tab, do one of the following:
Click the Build button
next to the InputMask property to start the Input Mask Wizard, and then follow the instructions in the wizard dialog boxes.Type the input mask definition. For more information on defining the input mask, click the InputMask property box and press F1. You must type the input mask definition manually for Number and Currency fields.
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:
Type the input mask definition.
In a Microsoft Access database (.mdb), 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.