Combo Box question

[JackV]

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.

[JackV]

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

[HeSaidJoe]

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.