Combo Box Autofill

[Gary Dolliver]

Hi all,
I was wondering if it was possible to delay the autofill in a combo box?
For example, if I was selecting color, I would type "R", but it could mean
either "Red" or "Royal Blue" - currently, if I was to type "R", RED would
show in the field, but I would only want RED to appear if I type "R...E..."
and then ROYAL BLUE would appear it I typed "R...O..."
Is this possible?
-gary

 

[Fred Boer]

Dear Gary:

You could do this by using Allen Browne's code here:

http://allenbrowne.com/ser-32.html

The code was designed to manage comboboxes with tens of thousands of
records, but it will do what you need as well...