Reducing entries within Combo Boxes

T

Tim

Is there a way to set up a Combo Box to reduce the number of entries that
appear when a user enters a value?

Example:
Let's a Combo Box list contains the entries 100, 101, 102, 103, 200, 201,
202, 203, 300, 301, 302, 303, etc...
The user pull down the list and types "3"
Is there a way to only show those entries that start with 3?
 
K

Klatuu

Tim,

The most obvious way is to be sure the Auto Expand property for your combo
box to True. This will not reduce the list, but it will move through the
list as you type. If you really want to limit it as you describe so theat
when you type a 3, only those that start with 3 will be in the list, then you
type 0 and only those that start with 30 wil be seen, then you might want to
experiment with the On Change event of the Combo. The change event fires
every keystroke. With this in mind, you could re establish your Row Source
property after every stroke. I would be concerned about repsonse time,
however, because there would be some delay in processing the code and
resetting the row source.
 
Top