Auto complete words

[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

 

[Dirk Goldgar]

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

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.

 

[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