Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dropdown box auto search...

Status
Not open for further replies.

billmo

Programmer
Feb 4, 2004
4
US
I have a drop down box populated by a query sorted in ascending order. I want to be able to allow the user to type first few letters of the value they want to select, and the box automatically scrolls to the nearest matching value. For example, if the user types 'd' in the drop down box, the list scrolls to the first 'd' name (David); and if the user types 'do' it scrolls to the first 'do' name (Doris) and so on. Can this be accomplished with Access VBA?
 
Right-click on your combo box, go to the Auto Expand property and set it to Yes.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top