Microsoft KB Archive/208972

= ACC2000: Input Mask Fails to Allow Correct Insertion of Numeric Literals =

Article ID: 208972

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208972



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
If you create an input mask that contains a numeric literal for a field, and then type a number in the field that is part of that numeric literal, the number is not entered in the field unless you type it twice.



CAUSE
This behavior occurs because Microsoft Access determines that the character that you type matches the literal that you defined in the input mask, and moves you to the next non-literal position in the input mask.



RESOLUTION
To resolve this problem, follow these steps:  Start Microsoft Access; in the Database dialog box, under Objects, click Macros, and then click New. Create the following macro:

SendKeys Action

Keystrokes: {F2}

Wait: No

 Open the form containing the field with the input mask, and then click Design View on the View menu. Click the field that you want, and if the Properties window is not visible, click Properties on the View menu. In the On Enter box, specify the macro that you just created.</ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="references_section">