Copy Caption to Clipboard

[ozsupra]

Sorry for being a pain however I am trying to copy a caption from a form to the clipboard so that I can later paste it into another application.

The code I have found via a search on this website 1) Clears the clipboard and then 2) copies the caption from a nominated field. 2) doesn't work as I sure I have the statements wrong.

Call EmptyClipboard

Me.B7_DB_GCUH.Caption
DoCmd.RunCommand acCmdCopy

This is probably very simple - sorry.
Adrian.

 

[JHB]

You can't do that, because DoCmd.RunCommand acCmdCopy required the control to be the active control, and you can't set focus to a label.