Select value for combobox with single char

[Fredrik]

Hello all,

I have a Combobox which has another table as rowsource.
I want for example "Apples" to come up when i type a "A" and then next
character "S" (AS) i want it to select "Asparagus" instead.

Quite simple i guess, but I do not know how to do this?

 

[fredg]

Hello all,

I have a Combobox which has another table as rowsource.
I want for example "Apples" to come up when i type a "A" and then next
character "S" (AS) i want it to select "Asparagus" instead.

Quite simple i guess, but I do not know how to do this?

Set the Combo Box's AutoExpand property to Yes.
it's found on the combo's property sheet's Data tab.

 

[Douglas J. Steele]

That's usually the default behaviour for combo boxes.

Make sure the combo box's AutoExpand property is set to True.

 

[Fredrik]

DOH!

It was not set as Combobox, the object was set to List.
The change to combobox helped.

Thanks for your concern anyway!

"Douglas J. Steele" skrev: