Auto complete

[Guest]

Does anyone know the code that automatically completes words or entries that
have previously been entered? Example, is when you are typing in Excel and
it automatically completes the word that you are typing in if you have
already entered it in the column above that row. Thanks in advance for any
help.

 

[Rick B]

This is an Access newsgroup.

If you are talking about Access, I have done this by making the field into a
combo box and setting it to all the unique values in that field. Then as I
type, it jumps down to the appropriate entries.