Reducing entries within Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top