Autocomplete options for Access data entry

[Guest]

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

 

[Jorge Luis]

Is there a way to use AutoComplete ( like in Excel ) for filling

out data fields in a MS Access database?

Recetas saludables y sabrosas

 

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

 

[Guest]

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?

 

[Guest]

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!