Re: How to do this in a list box?

From: Arvin Meyer (a_at_m.com)
Date: 02/22/04 

Date: Sat, 21 Feb 2004 22:53:43 -0500

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" <anonymous@discussions.microsoft.com> wrote in message
news:1468b01c3f888$0ff39c10$a501280a@phx.gbl...
> 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
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 2/20/2004