Microsoft KB Archive/122242

= ACC: LimitToList Enforced Even When Set to No =

Article ID: 122242

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q122242



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you type a unique value in a combo box and then press ENTER, you may receive the following error message even though the combo box's LimitToList property is set to No:

In Microsoft Access 7.0 and 97:

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

In Microsoft Access 2.0:

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



CAUSE
Even if the combo box's LimitToList property is set to No, Microsoft Access limits entries to those in the combo box if the first column displayed in the combo box is not the bound column. This behavior occurs because Microsoft Access stores the bound column value when you enter a nonbound column selection. If you could enter a new value for the nonbound column, Microsoft Access would have no value to store for the bound column.



RESOLUTION
In order to allow unique entries in a column box, make the first nonhidden column in the combo box the bound column.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
In Microsoft Access 7.0 and 97:

 Open the sample database Northwind.MDB.  Create a new query and select Design View. Add the Products table. Add the following fields to the QBE grid:

     Field: ProductName Show: True

Field: ProductID Show: True  Save the query as Test Query1. Create a new form not based on any table or query.</li>  Add a combo box with the following properties to the form:

<pre class="fixed_text">     RowSourceType: Table/Query RowSource: Test Query1 ColumnCount: 2 BoundColumn: 2 LimitToList: No

Note that the bound column is column 2, which contains the ProductID field. The ProductName field will appear in the first column. </li> View the form in Form view.</li> Type New Cola in the combo box, and then press ENTER. Note that you receive the error message stated above.</li></ol>

In Microsoft Access 2.0:

<ol> Open the sample database NWIND.MDB.</li> Create a new form not based on any table or query.</li>  Add a combo box with the following properties to the form:

<pre class="fixed_text">     RowSourceType: Table/Query RowSource: Product Names and IDs ColumnCount: 2 BoundColumn: 2 LimitToList: No

Note that the bound column is column 2, which contains the Product ID field. The Product Name field will appear in the first column. </li> View the form in Form view.</li> Type New Cola in the combo box and then press ENTER. Note that you receive the error message stated above.</li></ol>

<div class="references_section">