ACC: Input Mask with Numeric Literals Inserts Incorrectly

• Microsoft Access versions 2.0, 7.0, 97

SYMPTOMS

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

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

CAUSE

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

RESOLUTION

In the form containing the field with the input mask, specify the following macro in the field's OnEnter property setting:

   SendKeys Action
   -------------------
      Keystrokes: {F2}
      Wait: No

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access versions 2.0, 7.0, and 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

1. Create a new table with one field with a Number data type.

2. Set the field's InputMask property to:

         "19"## (make sure to include the quotation marks)
   

3. Save the table, and then view it in Datasheet view.

4. Type "89" (without the quotation marks) in the field. Note that the field displays "1989," as is expected.

5. In the next cell, type "94" (without the quotation marks). Note that "19 4" is displayed in the cell. The 9 you entered is not displayed.

REFERENCES

For more information about the SendKeys action, search the Help Index for "SendKeys action," or ask the Microsoft Access 97 Office Assistant.