ACC: Error Message with Blank or Incorrect Data Type

ID: Q90103

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0

SYMPTOMS

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

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

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 kbusage TblFldp 
Version           : 1.0 1.1 2.0 7.0
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: March 11, 1999