Microsoft KB Archive/209610

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

PSS ID Number: 209610

Article Last Modified on 11/29/2000

-

The information in this article applies to:


 * Microsoft Access 2000

-



This article was previously published under Q209610



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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
If the Limit To List 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:

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



CAUSE
The error message occurs because there are duplicates in the list. For example, if you type the value co in the combo box, and the values conf and cond are both in the list, the error occurs.



Steps to Reproduce Problem
 Start Microsoft Access and open any database. Create an unbound form. Create a combo box, and then in the Combo Box Wizard, click Cancel. Set the following properties in the combo box:

Row Source Type: Value List

Row Source: conf; cond

Limit To List: Yes

Auto Expand: No

 Switch to Form view. Type co, and then press ENTER. Notice that you receive the error message described in the &quot;Symptoms&quot; section.</li></ol>

<div class="references_section">