Copying a field to multiple fields

[helpless]

Access 2003 - Is there any way to copy/drag data from one field to multiple fields in the same column?

[nico5038]

Not without code that I know.
For multiple fields the "Access" way will be to create an UPDATE query, or when you store the data in a linked Excel sheet you can do the trick there...

Why the need ?

Nic;o)

[helpless]

Thanks for your response. I have never been able to figure out how to do this, I think because if will only copy and then paste to the same exact number of fields. I do this alot in dbs where I have people who meet the same criteria for something, e.g. state, so It would be nice to be able to copy and paste it for all rather than for each one.

thanks again

[nico5038]

Might be interesting then to check the sample from the Access CookBook:
9.5 Carry Data Forward from Record to Record
It's description is found at:
http://www.oreilly.com/catalog/accesscook2/
And following the "examples" link and selecting CDROM will allow you to download the Chapter 9 samples. 09-05.mdb will be the one to inspect.

This way a user can carry forward the fields needed when entering the data.

Nic;o)

[helpless]

Thanks, I read that and realized I guess I wasn't specific.

I am using a table only, not a form, it seems like that language is referring to a form with a toggle button.

thanks, helpless

[NeoPa]

You can't Copy/Paste from one record to many, but you can copy a set number of entries for the same field(s) then paste them to the same number of records elsewhere.
Not ideal, but can save some time.
Using Excel to enter a single value into multiple cells (Ctrl-Enter) and then Copy/Pasting across to Access can also work.