Create a button to copy to clipboard
2

Question

Create a button to copy to clipboard

BSman (Programmer)

(OP)

18 Oct 05 14:49

I need to provide a button which, when clicked, will copy a formatted set of text to the clipboard. Does someone know some VBA code to copy a text string to the clipboard? In code I will combine the values in a number of controls to make one text string to copy to the clipboard, but I don't know how to copy to the clipboard (without using <Ctrl><C>).

Bob S.

PHV (MIS) · Answer 1 · 2005-10-18 14:58:03

without using <Ctrl><C>
DoCmd.RunCommand acCmdCopy

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

BSman (Programmer) · Answer 2 · 2005-10-18 15:15:34

I don't think that this will work with a variable that contains the text, but I figured out a workaround by setting up a text box of 0" width (so it basically was not visible, although visible must be set to Yes for the copy to work). I placed the text in that control, set focus to that control, and then ran the command you provided. Here's the code I ended up with (for the button):

Me.txtCopyText = "This is a test"
Me.txtCopyText.SetFocus
DoCmd.RunCommand acCmdCopy

Thanks,
Bob S.

Come Join Us!

Posting Guidelines

Create a button to copy to clipboard
2