Microsoft Office Tutorials and References
In Depth Information
display characters. To include these characters, you need to create an input mask , a pre-
defined format used to enter and display data in a field. An easy way to create an input
mask is to use the Input Mask Wizard , an Access tool that guides you in creating a pre-
defined format for a field. You must use the Input Mask Wizard in Design view.
To use the Input Mask Wizard for the Phone field:
1. Switch to Design view, and then click the Phone Field Name text box to make
that row the current row and to display its Field Properties options.
2. Click the Input Mask text box in the Field Properties pane. A Build button
appears to the right of the Input Mask text box.
3. Click the Build button next to the Input Mask text box. The first Input Mask
Wizard dialog box opens. See Figure 5-35.
Input Mask Wizard dialog box
scrollable list o f
s ample values for
You can scroll the Input Mask list box, select the input mask you want, and then
enter representative values to practice using the input mask.
4. If necessary, click Phone Number in the Input Mask list box to select it.
5. Click the far left side of the Try It text box. (___) ___-____ appears in the Try It
text box. As you type a phone number, Access replaces the underscores, which are
Trouble? If your insertion point is not immediately to the right of the left paren-
thesis, press the key until it is.
6. Type 9876543210 to practice entering a sample phone number. The input mask
formats the typed value as (987) 654-3210.
7. Click the Next button. The next Input Mask Wizard dialog box opens. In it, you can
change the input mask and placeholder character. Because you can change an
input mask easily after the Input Mask Wizard finishes, you’ll accept all wizard
8. Click the Finish button. The Input Mask Wizard creates the phone number input
mask, placing it in the Input Mask text box for the Phone field. See Figure 5-36.