Using repeated keystrokes to rapidly navigate a combobox

  • Thread starter Thread starter Roach
  • Start date Start date
R

Roach

I don't know if this is even a good approach to my issue, but here
goes: I have a form with a combobox which is populated with guide names
which are alphabetized, based on a query. All works well. But my combo
box list is very long and I'd like to shorten the time it takes to get
thru the list to select a guide. My thought is to make it behave like
some list/combo boxes one sees on the web where if one types, say the
letter, 'g' repeatedly, you can scroll down a big list pretty quickly.
For example, if you navigate to: http://jobsearch.usajobs.opm.gov/ then
click in the Location Search box and hit the letter "g" 9 times, you
get, "GA-Ft Stewart & Hinesville." Is there a way to replicate this
behavior in Access Forms? Thanks for your thoughts.
 
It really depends on how large the list is..

However, if you sort that list, and set the combo boxes "auto expand" to
yes, then as you type, the combo box does in fact narrow down. (and, in fact
does much better then that web site, as that only lets you work via the
first letter..and if there is 50 names that being with, then that solution
is not much good! With the combo, you type in smi, and it drills/narrows
down to show ONLY the names that start with smi.

I should mention that this setting for a combo box is usually the default,
so I don't know why this is not working for you in the first place??

You can use the standard web keys alt-down arrow to "drop" the combo box,
and again typing the first few letters of the combo will cause it to auto
"drill" to the close match. As mentioned, you do need to sort the sort order
in the combo for this to work.....

And, if the list is longer then a few hundred, then perhaps a combo box is
not the best choice., I give some screen shots and more thoughts/ideas on
searching here:
http://www.members.shaw.ca/AlbertKallal/Search/index.html
 
Back
Top