Combo Box List - Suggestion as I type (not just beginning matches)

[Mr Retirement]

Hello,

I'm relatively new to access so thank you for providing any insight you can.

I have a Combo box in a Form that lists a bunch of names. I have the source of this dropdown pulling from a table called 'names'. When a user clicks the dropdown in the Form and then begins typing - it naturally will narrow the population showing to names that begin with whatever the user typed. Is it possible to have the list narrow the population showing to include other matches within the names not just the beginning?

Example: a user types "Jo" ... It would currently show "John Smith" as an option but it would not show "Sam Jones" as an option because it doesn't start with "Jo".

Thanks for any advice!
Mr R.

 

[welshgasman]

A quick Google brings this up.?

https://www.tek-tips.com/viewthread.cfm?qid=1756368