anyone come up with google type auto complete text box

[Chris K]

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

 

[Allen Browne]

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.

 

[Mike Painter]

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.)