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.

   --
   Wayne Morgan
   MS Access MVP

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>