Printable View
I have a combo box that is populated from an Access table. How would I make so that that when the user types in the combo box it skips down/up to the item in the list that matches the spelling (like bound Access/VBA combo boxes)
Right now it doesn't go past the first letter. I assume I have to put code in the change event but I'm stuck. Thanks in advance for any help.
-Jack
Set the Style to 2.
Thanks Megatron,
But I need it to skip to the correct entry after more than 1 character is entered as well. For example if the combobox contains the following:
Apples
Apricots
Pears
Should the user type "Apr", I would like it to jump to "Apricots"
As of now, when the user types "Ap", it jumps to "Pears" as soon as the "p" is entered.
-Jack
use the Microsoft DBBound Combo
Style=2
Matched Entry = 1
Will not show it in the text section but will advance it to the 1st. position below the text box.