How to do this in a list box?

[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

 

[Andrew Smith]

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.

 

[Arvin Meyer]

There are several examples on my website. This first doesn't change anything
until the search button is pressed. The second works similar to a combobox:

http://www.datastrat.com/Download/Search97.zip

http://www.datastrat.com/Download/ExpandingSearch97.zip

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Mike]

That's great. I was trying to do this in the list box but
your solution will work well.

Thanks very much.

- Mike