Value List

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a form with a value list of 20,000 customer
records. Is there a way to have the user either type in
part of the name, into a text box maybe, and go to that
part of the alaphabet? Originally I had a form of all
20,000 and had a text box that would use a filter to
narrow down names, but if the user entered an invalid name
there would be zero results.
Thank you.
 
Scott said:
I have a form with a value list of 20,000 customer
records. Is there a way to have the user either type in
part of the name, into a text box maybe, and go to that
part of the alaphabet? Originally I had a form of all
20,000 and had a text box that would use a filter to
narrow down names, but if the user entered an invalid name
there would be zero results.
Thank you.
Click to expand...

A combo box does this with the first part of the name.
There is a limit on the number that this will work on and it seems to be
about 64k
If you have just the name it might fit.
If not it will do what you want up to a point.

Type B and it goes to the first "B", r and you are at the first Br, etc

For one of my applications along about the letter "T" it stops selecting.
you can type in Thomas and it will get the first Thomas but it does not
scroll anymore.

This is a silly limitation and there are solutions available.
Buttons A-F, G-L, M-R, S-Z can be set to filter the names for the list box.
 
Back
Top