The information in this article applies to:
Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). SYMPTOMS
When you use the exclamation point character (!) in an input mask, the
characters do not fill from right to left as you type them. Instead, the
characters fill from left to right. !\(999") "000\-0000;;_characters fill from left to right as you type them. CAUSE
The exclamation point character does not affect how characters fill into
the input mask when you type them. Characters typed into the input mask
always fill from left to right. The exclamation point character determines
how committed (or existing data) is displayed in the input mask.
NOTE: This example differs from the input mask created by the Input Mask Wizard because not all the characters in the input mask are required. MORE INFORMATIONIf you type the number 5550248 into the following input mask created by the Input Mask Wizard !\(999") "000\-0000;;_you receive the following error message: You receive the error message because the first three digits of the number are entered and validated into the area code part (999") of the input mask; then, when you type the rest of the digits and try to commit the data, the last three required digits of the phone number input mask are blank. You can work around this behavior by using a more generic input mask, together with a validation rule. If you use the following example input mask and validation rule, you can type digits anywhere in the input mask even though the digits still fill from left to right when you type them: NOTE: The input mask does not contain any required digits; the required digits are handled by the validation rule.
REFERENCESFor more information about input masks, click Microsoft Access Help on the
Help menu, type "validate values entered in a field, record, or control" in the Office Assistant or the Answer Wizard,
and then click Search to view the topics returned. Additional query words: prb
Keywords : kbdta GnlInpt |
Last Reviewed: May 25, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |