Copying a created address block/joining fields

[CPAZ]

I'm relatively new to Access, but have successfully created a contact database using a table and then a form for data entry. Although I was able to create a separate address block from existing fields, I'd like to be able to copy information from that block to paste into other applications. Pllllllllllllllllllleeeeease help!

 

[Wayne Morgan]

You could use code similar to this in a button's Click event.

Me.Text0.SelStart = 0
Me.Text0.SelLength = Len(Me.Text0.Text)
RunCommand acCmdCopy

 

[Wayne Morgan]

Sorry, I had to run off for a few minutes, so I didn't get to finish the
previous post. For the previous example to work, the control has to have the
focus. You can also do it all without the focus by using API calls to write
to the clipboard. You can find an example of that here:

http://www.mvps.org/access/api/api0049.htm