Re: How to do this in a list box?

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

Date: Sun, 22 Feb 2004 05:32:15 -0800

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

Thanks very much.

- Mike

>-----Original Message-----
>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
>
>
>.
>