Initially the combo box (cboSearchName) was working fine but for no apparent reason it now works for only the first two characters typed. In other words, if I have the names Smith and Small; Small appears (as it should) when I type SM. If I continue to type SMI, the "I" is inserted before the "all". If I continue to type out SMITH, I end up SMITHall. At the second letter, the "lightning bolt" appears and I have the option to Auto-Correct. None of the Auto-Correct options allow me to type SMITH. Is there some VBA code I can add? I've tried Auto Expand ON and OFF.
Comment