Combo Box typing a Character does nothing

L

Lowe5000

I have a combo box to find records on a form and this is working perfectly -
BUT even though it is set to Limit to list it will not jump to the V entries
once you type V or v.
Strange: I add a new combo box (using the wizard) to the form it will work.
Stranger: my original combo box starts working too!

Getting hopping mad:
Closing and reopening the database none work anymore (unless of course I
add a new combo box...)

Not to get me wrong: finding the records works, you just have to find the
entry in the combo box by scrolling down.
 
D

Daniel

You have mixed up your terms.

What you are talking about is "Auto Expand"

You can use the AutoExpand property to specify whether Microsoft Access
automatically fills the text box portion of a combo box with a value from the
combo box list that matches the characters you enter as you type in the combo
box.

The "Limit to List" controls whether a user can add to the listing in the
combo box. I know that this property does control in a round about way the
auto expand functionality but you are best actually defining the Auto expand
property than relly on the Limit to List to do it. As you can see it can be
quarky depending on the scenario.

Daniel
 
Top