Filter Data in Combo Box or List Box as you Type

In this Microsoft Access tutorial, I'll guide you on how to filter data in a combo box or list box as you type. This skill is especially useful when you're trying to locate text that isn't at the start of the combo box and doesn't appear automatically due to the auto-expand property.

Sam from Jacksonville, Florida (a Platinum member) asks: I just watched your search-as-you-type video, and I think it's awesome! Thank you for that. Is there any way you can apply the same technique to a combo box or list box? I'm looking for a functionality where, as I type characters, it will filter the results in that box to show just the records that contain that text, regardless of where it appears in the field.

Members

There is no extended cut, but here's my database:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA: https://599cd.com/IntroVBA
• SQL with Access: https://599cd.com/SQLwithAccess
• Relational Combo: https://599cd.com/RelationalCombo
• Wildcard Search and LIKE: https://599cd.com/Like
• Double Double Quotes: https://599cd.com/DoubleDouble

Links

• Invoicing: https://599cd.com/Invoicing
• Search As You Type: https://599cd.com/SearchAsYouType

Recommended Courses

• Access Developer Courses: https://599cd.com/Developer
• Access Search Seminar: https://599cd.com/SearchSeminar

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Filter combo as you type, rowsource, requery combo, on change, text property, auto expand, filter combo box, filter list box