I have a subform with 4 combo boxes on it. They are all set to Auto Expand = Yes, and Limit to List = Yes. 3 of them work properly in all respects. The 4th one works like all the others except that the Auto Expand feature doesn't expand to find the nearest typed match.

I have done a side-by-side comparison with the properties of the working combos, and all settings look exactly the same (except for things like the column widths and such). Of course the row source is different, but typing in a complete entry or picking from the dropdown works fine. All of the combo's row sources are independant "Select" statements and have nothing to do with the main form.

Any thoughts on what might be causing the odd behaviour in the one combo?

Anthony J. Kroes