Is there a way to Copy one cell and Paste to multiple cells in Access?

[3dmap1]

A department at my office uses an old MS-Works database. The employees there like it because it is simple to use. I designed a database in MS-Access (2000) that essentially works the same and is easy to use (which is what they want and need).
The one problem I have which works better in Works than in Access is that when they are entering customer information in the Works database table (like mailing addresses),if the city is the same for 60 records, they can type the city in the 1st cell, hit copy, highlight the other 59 cells and hit paste. In Access, if you copy one cell, you can only paste to one cell, if you copy 3 cells, you can paste to three cell and so on.
Is there a way to rectify this that will be easy for these employees to use? They could use Excel to enter the information and import it to Access but that would be more hassle for them and they would just rather keep using Works.
Any help or advice would be appreciated.

 

[johnnymac43]

I can't think of an elegant solution, but you can set up nested macros so that one does the Copy and controls the Paste loop, while the other does the 'Find next field to paste into' and the Paste.

The 'Find next field' parameters would probably be:
Find What: is null
Search: Down
Only Current Field: Yes
Find First: No

The challenge you will have is how to enter the number of times to execute the Paste loop (and how to convince your users to use this method)

Cheers

John