Combo box to increment search AND hide others

  • Thread starter Thread starter Song Su
  • Start date Start date
S

Song Su

I know how to use combo box to search names. I want it to do further: hide
those not starting the character I'm typing. For example:

When I type the 1st letter S, it shows all the name starting with S and hide
those starting T, U, V etc. When I type 2nd letter M, it shows the name
starting with SM but hide those staring SN, SO, SP etc.

Is it possible?
 
It can be done, but I would advise against it. It takes a lot of VBA code
and because the way it has to be done, it will make the combo very sluggish.
Most people can type faster than it could respond. That is because you have
to modify your row source for every keystroke and requery the combo. If you
want to try it, use the combo's Change event. It fires after every keystoke.
I call tell you the users will hate it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding scroll bar in combo box 7
combo box autofill 3
change in text box applies filter to combo box to show only those 3
Combo Box Limitation? 3
combo box fills in arbitrary value 7
Search with a Combo Box 2
Combo boxes 12
Combo Box Search 3

Back
Top