Autocomplete

[Tami]

Does access have an autocomplete feature like Excel? I am
using Office 2000. I have an employee database in Access.
When I enter records into the table, I am having to enter
department name information. There are over 100 different
department name. With so many names a lookup column is
not an option. Is there another way to have the
department name generate, like the autocomplete feature
in Excel, so when I start to type I can just press enter
in that field or are there any other options?

Thanks in advance for your help.

 

[Wayne Morgan]

There is an option to do this with a combo box.

 

[Guest]

Thanks Wayne. I don't know why I didn't think of this.