Jump to a Value in a Listbox

  • Thread starter Thread starter Mark Wolven
  • Start date Start date
M

Mark Wolven

I'm not even sure what specifically to ask for, so - I'll describe it
as fully as I can:

I have a listbox in a form that has a lot of records in it (~18000)
that users need to select. When you type a letter - "A", the list
jumps down to the first record that begins with the letter that you
type.

With so many records, there can be a large number of records between
Aa___ and Aw___ - is there a way to get access to wait for a second
character? Or at least read the user input as 2 characters of they
type it fast enough?

As it is now, if the user types "AW" quickly, Access jumps to the
first W___ record.

Any thoughts?
 
I'm not even sure what specifically to ask for, so - I'll describe it
as fully as I can:

I have a listbox in a form that has a lot of records in it (~18000)
that users need to select. When you type a letter - "A", the list
jumps down to the first record that begins with the letter that you
type.

With so many records, there can be a large number of records between
Aa___ and Aw___ - is there a way to get access to wait for a second
character? Or at least read the user input as 2 characters of they
type it fast enough?

As it is now, if the user types "AW" quickly, Access jumps to the
first W___ record.
Click to expand...

Could you consider using a Combo Box instead of a Listbox? The
autocomplete feature of a combo works in exactly the way you describe.
And with 18000 records, you lose the main benefit of listboxes over
combos (being able to see all the values onscreen at once).
 
Back
Top