ACC: Error Message with Blank or Incorrect Data Type (90103)


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
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.

MORE INFORMATION

Steps to Reproduce Behavior


  1. Open a new table.
  2. Select any data type for the first row from the Data Type box.
  3. Remove the data type you selected by using either the DELETE or the BACKSPACE key.
  4. 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.
Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kberrmsg kbprb kbusage KB90103
©2002 Microsoft Corporation. All rights reserved.