Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

Character Description 0

A required numeric entry (0-9); plus and minus signs are not allowed An optional numeric entry (0-9) or space; plus and minus signs are not allowed An optional numeric entry (0-9) or space; plus and minus signs are allowed

9

#

L

A required alphabetic entry (A-Z)

?

An optional alphabetic entry (A-Z)

A

A required alphabetic (A-Z) or numeric (0-9) entry

a

An optional alphabetic (A-Z) or numeric (0-9) entry

&

Any character or space; entry required

C

Any character or space; entry optional

<

Causes all characters that follow to be converted to lowercase Causes all characters that follow to be converted to uppercase Enters the input mask from right to left, instead of from left to right Causes the character that follows to be displayed as a literal character

>

!

\

NOTE The Input Mask property can be set in Design view of any table, query, or form. Most of the time, you will want to apply an input mask to a field in table Design view, because it will then be automatically applied to the field in queries, forms, and reports. The Input Mask Wizard can only be used for Text and Date/Time fields. You must manually enter an input mask for Number and Currency fields.



Procedures

1. Open the desired table in Design view. 2. Select the field to which you want to apply an input mask. 3. Select the General tab in the Field Properties pane, if necessary.

OFFICEPRO, Inc.

Page 21