Predictable text in access

[Guest]

Is there a way to set up microsoft access to use the predictable text feature
in a database or form?

 

[Allen Browne]

A very simple way to do this is to use a combo box.
The combo will autocomplete the text if its AutoExpand property is on (the
default.)

If you want to use a text box, use its Change event to examine the Text
property.
Remember the SelStart in a variable.
DLookup() the nearest match.
Assign the value.
Set the SelStart to where it was, and the SelLength to the remainder (so the
user can keep typing to overwrite the remainder.)