Auto complete words

  • Thread starter Thread starter Graham Hughes, MVP Digital Media
  • Start date Start date
G

Graham Hughes, MVP Digital Media

Has access got the facility to auto complete words, the same as Excel has? I
have Office XP and it's Access 2002.
Cheers
Graham
 
Graham Hughes said:
Has access got the facility to auto complete words, the same as Excel
has? I have Office XP and it's Access 2002.
Cheers
Graham
Click to expand...

You mean, by looking into what has previously entered in the column?
It's not built-in, except in the case of the combo box control, which
can be set to autocomplete items from its list -- but if the list is
being drawn from the table being edited, it must be refreshed with code.

You can also write code to implement this feature on a text box, but as
I said, it isn't built-in. The main reason is probably that in a
relational database system, you should seldom be entering the same text
in multiple rows.
 
Cheers Dirk,
Thought that might be the case. Might compile it in Excel and then import it
to Access.
Graham
 
Back
Top