Autocomplete options for Access data entry

B

Bleu

Is there a way to use AutoComplete ( like in Excel ) for filling out data
fields in a MS Access database?
 
A

Allen Browne

No. In a correctly designed database, you should not have repeating data.

If you do have, consider creating another table to hold the possible values,
with a relationship between the two. You can then use a drop-down list to
select the value, and the combo's values will autocomplete for you.
 
T

Tarnia

What about when selecting data eg running a query to select for someone's
name? Is there a way to do it such that the entire name (or date, or
whatever) has to be entered?
 
T

Tarnia

Sorry Ignore last message...I just found another way to do what I was doing.
I was using a query but using a form and command buttons works much better!
 
Top