narrowing choices while typing

[rob c]

I need to set up a combo box that has multiple choices based on a table, but
then the choices are narrowed down by the characthers typed. Example:
List of choices
Door Repair
Door Install
Dryer replaced
Window Repair
Window Install
Winterize

If the user were to type "D", then Door Repair, Door Install, and Dryer
replaced would remain.
If the user then typed "o", then Door Repair and Door Install would remain
as choices.

Thank you

 

[Jeff Boyce]

Rob

The Access combobox does what you describe, if the LimitToList property is
turned on (only valid values can be found), and if the (I don't recall the
exact name of this one) "Autocomplete" property is turned on.

Now, it doesn't limit to only "Door Repair" and "Door Install", but it does
jump the the point in the list where those are located.

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

'AutoExpand' instead of "Autocomplete" property.

 

[Jeff Boyce]

Thanks, Karl. I can never remember that ... if only Microsoft had given it
the name I came up with...<g>.

Jeff B.