Currently using combos populated with list of data already used in this
field - then use code to expand the list when the user presses down arrow

but has anyone come up with google type auto complete text box

You could expand on Alllen's suggestion by building an index with the help
of the split functionon (almost) every word in the field. A "stop list"
dumps common words such as "as", "if", "to" and so on.

"The big red wagon". would index big, red, and wagon
"Red sails in the sunset" would store red, sails, and sunset.
Entering words in any order would return the relative records.

(And yes I "borrowed" this from Pick.)




Allen Browne wrote:
> It can be done, if you use the Change property of the text box to
> examine its Text (not Value), store SelStart and SelLength, lookup up
> the nearest match, assign this as its Value, and then select the
> remaining characters again.


>
> "Chris K" <(E-Mail Removed)> wrote in message
> news:Hz04o.103323$xf1.89595@hurricane...
>> Currently using combos populated with list of data already used in
>> this field - then use code to expand the list when the user presses
>> down arrow but has anyone come up with google type auto complete text box