Use auto complete feature when typing word in middle of field

[ezr]

I'm working with a DB to enter orders for picking. I have an item list that I'm linking to when entering orders, and bringing in the data from the item list such as item location etc.
It's setup right now that when I type the first couple of letters into the item field it automatically brings up the matching items and if I click enter it completes the item and brings in the other fields from the item list.
example: If I type in 'tom' I get back 'tomato', 'tomato sauce' etc. and when I choose the right one and hit enter it fills up the rest of the required info such as item location.
What I would like it to do is have the auto complete also check for middle words.


example: when I type 'alm' it returns 'almonds', 'almond milk', but don't return 'container almonds' or 'container roasted almonds' etc.
Is there a way to do that?

[June7]

So you want the combobox list to sort by finding the typed input anywhere in the string. I think not. AutoExpand cannot be changed. You could have the input into a textbox then set the combobox RowSource as:

SELECT [fieldname] FROM tablename WHERE [fieldname] LIKE "*" & [textboxname] & "*";

This is called cascading or dependent combobox.