Auto complete words

  • Thread starter Graham Hughes, MVP Digital Media
  • 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
 
D

Dirk Goldgar

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

Graham Hughes, MVP Digital Media

Cheers Dirk,
Thought that might be the case. Might compile it in Excel and then import it
to Access.
Graham
 
Top