Create a button to copy to clipboard
Create a button to copy to clipboard
(OP)
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.
Bob S.
RE: Create a button to copy to clipboard
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
RE: Create a button to copy to clipboard
Me.txtCopyText = "This is a test"
Me.txtCopyText.SetFocus
DoCmd.RunCommand acCmdCopy
Thanks,
Bob S.