Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

11. Select the Placeholder box. 12. Type the desired placeholder. 13. Select the Sample Data box. 14. Type some sample data.

15. Select . 16. Select the custom input mask from the Input Mask list.

17. Select

.



Step-by-Step

Create a custom input mask.

Open the Items table in Design view.

Steps

Practice Data

1. Select the field to which you want to apply a custom input mask. The field is selected. 2. Select the General tab in the Field Properties pane, if necessary. The General tab appears.

Click in the Product ID field, if necessary

Click the General tab, if necessary

3. Select the Input Mask box.

Click in the Input Mask box

The Build button appears to the right of the Input Mask box.

4. Click the Build button.

Click

The Input Mask Wizard opens.

5. Select Edit List .

Click

The Customize Input Mask Wizard dialog box opens.

6. Select the New button. A blank form appears.

Click

7. Type the desired description for the custom input mask. The text appears in the Description box.

Type Product Number

OFFICEPRO, Inc.

Page 25