Combo Box To Bring Up List base on typing a few letters

[Shon Baker via AccessMonster.com]

I have a long combo box of names. Is there a way to type in a few letters
and have the list shrink to only those records that match. I'm look for a
way similar to how EXCEL would operate. In Excel column, if you type the
first few letters, you get a shorter list of options to chose from.

Is this possible in Acess?

Thanks,
Shon

 

[Marshall Barton]

I have a long combo box of names. Is there a way to type in a few letters
and have the list shrink to only those records that match. I'm look for a
way similar to how EXCEL would operate. In Excel column, if you type the
first few letters, you get a shorter list of options to chose from.

Well, it doesn't shrink the list, but the AutoExpand
property moves the position in the list to the first item
that matches what you typed so far.