Macro to copy to field contents

  • Thread starter Thread starter BFB
  • Start date Start date
B

BFB

How do I create a macro that will copy the contents of a
field? In form view I have a field [FullAddress] and
want to create a command button tied to a macro that will
copy (clipboard) the contents of [FullAddress]. I then
can open a letter template in word and paste the
[FullAddress] at the top like a mailing label.
 
This can be done in various ways, but not by "copying" and "pasting" the
value by a macro.

Instead, you can use a macro to "read" the value from a control and then
"write" it into another control (even between applications). This macro
could run in ACCESS or in WORD (where it would be VBA code); if in ACCESS,
Word document needs to be open and have a known filename.
 
Back
Top