List Box parsing

  • Thread starter Thread starter Annemarie
  • Start date Start date
A

Annemarie

I have a listbox with around 10,000 inventory entries and
most of them start with an "A". So rather than asking the
user to go through all 10,000 entries to find which one
they need, is there a way they can type ..for example
A1000__ and that would take them down to the first A1000__
entry..and then they can start scrolling from there?
Because even though all entries are sorted...its time
consuming to go through all of them to find something.

any help would be appreciated.
 
Use a combo box instead of a listbox. Its built-in autocomplete feature will
do exactly this for you.
 
I am also having a simular problem with a Access. The
database has a list box and when typing in to the box it
would pull up the number or name (I have several in this
program only two have stopped working) you would only need
to enter the first couple of letters/numbers and the table
would pull up, if the entry did not exist you could enter
a new entry. It now does not work. You HAVE TO scroll
down and pick a entry from the table, even if you enter a
correct entry that is in the talbe it errors and says it
is not. This did work for a long time, The only thing I
can come up with is that the list is to long. Is this
possible or any ideas what I can do or look for. the form
was designed to make entering faster and instead it takes
longer,
 
A list box does not let you enter values other than the first character of
the first visible column. I'm not sure what you mean by "typing in to the
box"?

If you're referring to a combo box and the autoexpand (I erroneously had
called it autocomplete -- never trust your memory!) feature is not working
any more, it's possible that your default setting has been changed for that
combo box. Open the form in design view, click on the combo box, click on
Properties icon on toolbar, and click on Data tab. Check that the Auto
Expand property is set to Yes.
 
Back
Top