Hello,
There are many threads on this subject but I can't find the
answer for my particular situation in Access 2000. I have a populated
combo box that my users would like to work as a "Smart Search". In
other words, they want to start typing the entry they are after and
have the combo box search down matching, not only the first letter, but
all succesive letters.
EXAMPLE: "B", "U", "L" separates "Bull Moose" from "Buckeye"
This works in two cases:
Case 1: If they click the down arrow on the combo box, it drops
down, and they can start typing until reaching the desired entry and
then hit enter.
Case 2: If they tab into the combo box, the entire line is
highlighted so they can start typeing as in case 1:
This does not work:
Clicking on the combo box (Not the drop down) arrow. I tried
using the Enter and/or GotFocus events to force highlighting the entire
entry with:
Me.VendorCombo.SelStart = 0
Me.VendorCombo.SelLength = 100
But no highlighting takes place so any keystrokes just end up
in the current text.
Thanks,
Hank Reed