Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

-

Creating a custom Input Mask

NOTE Input masks are saved to your user profile on your system, not to the individual database file. If you create a new mask, or modify a default one using the Customize Input Mask Wizard dialog box, the changes are permanently saved to your system settings.



Procedures

1. Open the desired table in Design view. 2. Select the field to which you want to apply a custom input mask. 3. Select the General tab in the Field Properties pane. 4. Select the Input Mask box. 5. Click the Build button .

6. Select the Edit List button

.

7. Select the New button . 8. Type the desired description for the custom input mask.

9. Select the Input Mask box. 10. Type the custom input mask.

Page 24

OFFICEPRO, Inc.