Can Access autofill cells from partial entries, like Excel can?

[Jim from Baltimore]

Can I set entry instructions, preferably in a Form, in which typing Moz, for
example, triggers an autofill of Mozart, Wolfgang Amadeus, if that name is in
a previous entry. Does this require indexing, and how do I instruct the
cells to autofill? I have been able to do this in Excel, but can't find out
how to do it in Access. Thanks.

 

[Douglas J. Steele]

The only way would be to use a combo box rather than a text box.

 

[Guest]

Also, Access has Office AutoCorrect, like Word, or you can use
code to autofill (sometimes useful when you have hundreds of different
items or thousands of identical items in the list).

(david)