Microsoft Office Tutorials and References
In Depth Information
Phone number input mask created by the Input Mask Wizard
input mask for a
The characters used in a field’s input mask restrict the data you can enter in the field,
as shown in Figure 5-37. Other characters, such as the left and right parenthesis in the
phone number input mask, that appear in an input mask are literal display characters.
Input mask characters
Input Mask Character Description
Digit only must be entered. Entry is required.
Digit or space can be entered. Entry is optional.
Digit, space, or a plus or minus sign can be entered. Entry is optional.
Letter only must be entered. Entry is required.
Letter only can be entered. Entry is optional.
Letter or digit must be entered. Entry is required.
Letter or digit can be entered. Entry is optional.
Any character or a space must be entered. Entry is required.
Any character or a space can be entered. Entry is optional.
All characters that follow are displayed in uppercase.
All characters that follow are displayed in lowercase.
Enclosed characters treated as literal display characters.
Following character treated as a literal display character. This is the same as
enclosing a single character in quotation marks.
Input mask is displayed from right to left, rather than the default of left to
right. Characters typed into the mask always fill in from left to right.
The character between the first and second semicolon determines whether
to store in the database the literal display characters. If left blank or a value
of 1, do not store the literal display characters. If a value of 0, store the lit-
eral display characters. The character following the second semicolon is the
placeholder character that will appear in the displayed input mask.
Sarah wants to view the Phone field with the default input mask before you change it