Microsoft KB Archive/96901

= ACC: LimitToList Property Set to Yes Needs a Unique Entry =

Article ID: 96901

Article Last Modified on 1/18/2007

-

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
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q96901



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



SYMPTOMS
If the LimitToList property of a combo box is set to Yes, and you type a portion of an entry into the combo box and press ENTER, you may receive the following error message:

  In Microsoft Access 7.0 and 97:

The text you entered isn't an item in the list.

  In Microsoft Access 1.x and 2.0:

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



CAUSE
The error occurs because there are duplicates in the list. For example, if you enter the value &quot;co&quot; in the combo box and the values &quot;conf&quot; and &quot;cond&quot; are in the drop-down list, the error occurs.

