How to do this in a list box?

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi.

I'm using Access 97 and am wanting to know if there is a
way to configure a list box so that the user can type in
several characters quickly and be taken to the first row
matching those values.

For example, if the list has values ...

Albert
Amanda
Barbara
Bert
Betty
Bob
Charlie
David
Ernie
Frank


.... the user types BE, I'd like the user taken to Bert
rather than to Ernie.

I know this works by default for a single character. The
list will always be sorted alphabetically.

Thanks.

- Mike
 
This is the default behaviour of a combo box. You can also simulate it with
a combination of a text box and list box - use the change event of the list
box to modify the contents of the list box.
 
That's great. I was trying to do this in the list box but
your solution will work well.

Thanks very much.

- Mike
 
Back
Top