Originally Posted by
June7
...As you type in combobox, the list pointer will move to first item that matches the input. Make sure AutoExpand is set to Yes and the matched value will display in box...
And since Yes is the Default Setting for the AutoExpand Property...if it's not moving to the first partial match (and you didn't mistakenly set the Property to No) you'd have to consider the possibility that the Combobox is corrupted.
Although we usually think of Forms, and even entire Databases, when we speak of corruption, Controls, such as Comboboxes, can and do become corrupted, and seem particularly susceptible to this during app development. The test/cure for this is short and simple...delete the Control and then re-create it.
As for automatically dropping down the list, as June7 suggested, when entering the Combobox, to make the first few matched immediately visible, that's easy...replacing cboComboName with the actual name of your Combobox:
Code:
Private Sub cboComboName_Enter()
cboComboName.Dropdown
End Sub
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007