ACC: Error Message with Blank or Incorrect Data Type

Last reviewed: May 28, 1997
Article 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
Hardware : x86
Issue type : kbprb
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.