Create an input mask (MDB)

Microsoft Office Access 2003

  1. Open a table in Design view.
  2. In the upper portion of the window, click the field you want to define an input mask for.
  3. In the lower portion of the window, do one of the following:

    Click the Build button Button image 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.

Show Create an input mask for a field in query Design view

  1. Open a query in Design view.
  2. 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.
  3. Click Properties Button image on the toolbar to open the property sheet for that field.
  4. On the General tab, do one of the following:

    Click the Build button Button image 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.

ShowCreate 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 PropertiesButton image on the toolbar to open the control's property sheet.
  3. 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 Button image in the Input Mask property box to start the Input Mask Wizard, and then follow the instructions in the wizard dialog boxes.