Copy the information of a field to the clipboard so I can paste it in a Word document using Sendkeys

[Eduardo Ellery]

I want to use Sendkeys statement to copy the information of a text field to the clipboard and then paste it in a Word document.

I used docmd.gotocontrol texto_documento to set the focus and then docmd.sendkeys "^C" to copy the text to the clipboard.

It did not work. I tried using macros, but it did not work either. What am I doing wrong?

[June7]

Instead of SendKeys try:

DoCmd.RunCommand acCmdCopy

[Missinglinq]

SendKeys should always be used as the absolute last resort, when nothing else will do the job, which isn't the case, here! I use the same command that June7 gave you, except that I believe you have to select the text, first, before copying.

I also idiot-proof it, in case the user hits the button when the target field is empty, which will cause an error, if I remember correctly:

If Nz(Me.TextboxName, "") <> "" Then
  Me.TextboxName.SetFocus
  Me.TextboxName.SelLength = Len(Me.TextboxName)
  DoCmd.RunCommand acCmdCopy
Else
  MsgBox "There's Nothing to Copy, Dummy!"
End If

Linq ;0)>!

[Eduardo Ellery]

June7's command worked perfectly. I will use the idiot-proof code Missinglinq gave too. Thank you both very much. Problem solved.

[Missinglinq]

Glad we could help, and welcome to AFN!

Linq ;0)>