How to do this in a list box?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Mike (anonymous_at_discussions.microsoft.com)
Date: 02/21/04 

Date: Sat, 21 Feb 2004 06:36:16 -0800

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

Relevant Pages

  • Re: How to do this in a list box?
    ... 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. ...
    (microsoft.public.access.forms)
  • Re: How to do this in a list box?
    ... 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. ...
    (microsoft.public.access.forms)
  • Re: How to do this in a list box?
    ... 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. ...
    (microsoft.public.access.forms)
  • Re: Replace certain characters in a string
    ... I am not sure if you are wanting to go through every record (would need to ... Fred Boer wrote: ... of characters with ASCII values below 32 with a single character (say a ... Could someone please suggest an efficient method to do ...
    (microsoft.public.access.modulesdaovba)