Will Access repeat typed data like Excel spreadsheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I work for a Regional Utility , am creating a data base of labretory results,
there is a large number of repeative entries ie: analysis results,sample site
addresses etc.
 
Using the CTRL+ ' keystroke will copy the value from the same field in
the previous record.


Another option posted in the past is....

You should be able to do this with combo boxes, filling the
row source of the combo box with unique entries from the field and
setting
the combo boxes Auto Expand to Yes. This would also allow the user to
pick
from the drop down list. You would need to requery the combo box
whenever a
new entry was made to add it to the list.
 
Michael

Not clear from your description, but whenever I see someone trying to handle
"a large number of repetitive ... addresses", I wonder if the data structure
has been normalized?

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top