Microsoft KB Archive/104975

{|
 * width="100%"|

ACC1x: Typing in Combo Box Does Not Select Item

 * }

Q104975

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
Typing a value in a combo box does not automatically select that value in the combo box.

CAUSE
The LimitToList property of the combo box is set to No.

RESOLUTION
Change the LimitToList property of the combo box to Yes.

STATUS
This problem no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION
The LimitToList property determines if a combo box can accept new items. If the property is set to No, characters typed in the combo box cannot be used to select a list item because Microsoft Access does not know if you are entering a new value or want an existing value from the combo box.

If the LimitToList property is set to Yes, the combo box cannot accept new values. This enables Microsoft Access to use the characters you type for selecting a list item.

Steps to Reproduce Behavior
 Open the sample database NWIND.MDB. Open the Suppliers form in Design view.  Select the combo box at the bottom of the form.

     Object: Combo box -     ControlName: Company Pick List RowSourceType: Table/Query RowSource: Supplier List LimitToList: Yes  Set the LimitToList property to No. View the form in Form view. Click the arrow beside the combo box to open the combo box. Begin typing "Bigfoot Breweries" (without the quotation marks) and note that Bigfoot Breweries is not automatically selected until the last character is typed.</ol>