Combo/List Boxes

[refryguy]

Does anyone have a code to be able to scroll through a Combo Box or List Box with the arrow keys without having to open the list. I can scroll up and down if I open the list no problem but I'd like to be able to just start typing the value and scroll if possible.

Basically I have some values that start off with similar wording, for example my list has:

Plumbing Service
Plumbing Commercial


HVAC Service
HVAC Commercial

I'd like to be able to just start typing Plumb...and then use the arrow key to select the value. I tried some different macros but it only works when the entire drop down is showing.

Thanks,

Refry

[rpeare]

a combo box behaves the way you are asking with no additional coding required. if you were to type plumb in your example (assuming they were organized the way you have them) the first plumbing item would be found then if you hit the down arrow on the combo box you could search from there.

List boxes behave differently and are probably not what you want for what you've described.

[refryguy]

Thanks for the quick reply. True, I can arrow down but only if the Combo Box or List Box is dropped down. I'd like to be able to arrow up and down without having to open the drop down all the way.

I have tried as both a List Box an Combo Box but neither seems to work unless I pull the entire list down.

[rpeare]

I don't know if this will work as a solution but you can put this in the on enter property of your combobox

Me.cboMyCombo.Dropdown

It will automatically open the dropdown (or should) then I don't know what the behavior would be (I didn't test) you may be able to start typing then use your down arrows to scroll.

Here's where I plagarized it from:

http://www.pcreview.co.uk/forums/scr...-t1122141.html