ACC: Error Message with Blank or Incorrect Data Type

• 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

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.

• 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