Combo Box Select As You Type

[Learn2010]

I have a combo box on a form. In the gotFocus Event I have Combo1.Dropdown so that the user gets a list of 20 records when they enter the box and before they start typing. I can get the first matching record to come to the top as they type. For example, I type "sa" and get sac, sad, sag, etc.

Is there a way to have it highlight the first record when that happens?

Thank you.

 

[Pat Hartman]

NO. The first record is at the top of the list and should be obvious. Pressing tab completes the autofill if that is what you are after. Make sure that the RowSource is sorted by this text value or type ahead will not work correctly.