How do I turn on auto suggest for data entry?

[Guest]

2 Questions please -

How can I turn on auto suggest (the same as excel) meaning - when I start to
type something that I type all the time, how can I make it suggest it and I
just hit enter to accept?

Question 2 - Does access have a fill feature the same as excel - so that I
can select several cells and make them all say the same?

Many thanks in advance..

Sara

 

[Douglas J. Steele]

Excel and Access are two very different products. The only way you can get
Access to suggest an entry is if you use a Combobox.

Same comment for question two. Excel's fill feature makes little sense in a
relational database. Use an Update query instead.