List box selection as you type

[Guest]

I'm using Access 2003. I have a List BOx on a form bounded to a table. I'd
like this list box to behave like a combo box that is when you type some
letters, the selection of the row is done as you're typing :

Let's say you have :

ABCD
EEFF
EFGH
EFGG
EFHH

When you type : E, the first row starting with E is selected, then if you
continue typing F you have the first row strating with EF that is now
selected and so on..
Make any sens ?

 

[Roger Carlson]

The Access Developers Handbook has an example that does this very thing.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jeff Boyce]

What you're describing is discussed in Access HELP under "AutoExpand". I
believe (depending on version) it is available for combo boxes, but not list
boxes.

Is there a reason you would rather not use a combo box?

 

[Guest]

Hi,
why not use a combobox then? That's what they are made for!
HTH
Good luck