Pasting same term in multiple records

[PATRICKPBME]

In Excel I know I can copy an item, select a bunch of cells and then paste that info in all of the cells at once. Access doesn't seem to let me do that. I can copy and item and select a range of cells (records) where I want the information pasted, but it only allows me to paste the information in one record. What am I missing?



Thank you.

[davegri]

If pasting into tables, hold down the shift key first, then holding it down, click vertically in that column to select the target receiving fields. You can also select adjacent fields (a block of fields), but the block has to be contiguous.

[Micron]

Nothing. It wasn't and will never? be designed to do that as long as we're talking about selecting a range of table rows in one or more table fields. Access is a relational db, not a spreadsheet tool. The closest you can come to the desired behaviour is to Paste>Append from the ribbon. This will fail if the operation duplicates records in an indexed field or creates records on the many side of a one to many relationship.

We're talking about pasting into new rows in a table, not existing ones? For existing, I don't know.

[PATRICKPBME]

The paste/append was a good option. Thanks to all!