Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

4. Select the Input Mask box. 5. Type the desired input mask.



Step-by-Step

Create an input mask manually.

If necessary, open the Reps table in Design view.

Steps

Practice Data

1. Select the field to which you want to apply an 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 INITIALS field, if necessary

Click the General tab, if necessary

3. Select the Input Mask box.

Click in the Input Mask box

The insertion point appears in the Input Mask box.

4. Type the desired input mask.

Type >LLL

The text appears in the Input Mask box.

Save the changes to the table and switch to Datasheet view. Create a new record, select the INITIALS field (if necessary), type abc , and press [Enter] ; notice that the completed entry is formatted as all caps.

Press [Esc] to delete the new record and close the Reps table.

C REATING A C USTOM I NPUT M ASK



Discussion

The Input Mask Wizard provides a list of predefined input masks. If you frequently use an input mask that is not included with the predefined masks in the Input Mask Wizard, however, you may want to create a custom input mask. You may want to use

Page 22

OFFICEPRO, Inc.