How do I turn on Autocomplete in Access 2003 Forms?

[Guest]

Dear helpful people,

I am using Microsoft Access 2003 to create a large database that has lots of
different text field values. In these cells, the information I need to type
often repeats in separate fields. In Excel, there is an Autocomplete option
that automatically fills in text that appears to be repeating if it is in the
same column.

What I want to know is how (or if) I can turn on an Autocomplete option in
my form that works similarly to Excel so that the more tedious parts of my
database entry are sped up considerably. This could literally save me hours a
day if someone could help me.

Thanks for trying to help!

-John

 

[Guest]

A prev post given by Van T. Dinh MVP (Access)

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=210236

 

[Guest]

A prev post given by Van T. Dinh MVP (Access)

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=210236

I appreciate the help but that still does not answer my question. I am not
trying to copy the last field into the current field, I am trying to get
Access to suggest what it thinks I am wanting to type in the field based on
other things that I have typed previously.

For instance, when you have visited websites with Internet Explorer and you
want to go back to them later, all you have to do is START typing the web
address into the address bar and then a drop-down menu appears listing the
possible choices that you may want to pick from. I want this to happen, but I
want it done while I am typing information into forms in Microsoft Access
2003.

Another example: In Excel if you have typed the word Monkeys into a cell in
the Animals column, then the word Giraffe, then the word Hippo, and then
started typing in a fourth cell the letter M, Excel would automatically add
ONKEYS behind the M because it assumes that you want to type in Monkeys
again. I want my form to do THAT for me.

-John

 

[Guest]

Nobody knows?

-John

 

[ki1ian]

Autocomplete function in Access 2003

Hi folks,

It's been a while since anyone has looked at this thread. Does anyone have a soultion to this? Could a VBA script do the job?