Microsoft KB Archive/90103

= ACC: Error Message with Blank or Incorrect Data Type =

Article ID: 90103

Article Last Modified on 5/9/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q90103



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



SYMPTOMS
When you design a new table, you must select a valid data-type name from the Data Type box for each field; otherwise, you may receive the following error message:

The text you enter must match an entry in the list.



CAUSE
The error message is caused by the field validation that Microsoft Access performs when you exit the field.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
 Open a new table. Select any data type for the first row from the Data Type box. Remove the data type you selected by using either the DELETE or the BACKSPACE key. Try to move to the next row. Note that you receive the error message:

The text you enter must match an entry in the list.



The only way to move to another row is to do one of the following:


 * Fill in the Data Type field by selecting a data type from the Data Type box.
 * Cancel the entry by pressing the ESC key (which fills in the Data Type field with a default entry of Text).
 * Click Delete Row on the Edit menu.

Keywords: kberrmsg kbprb kbusage KB90103

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.