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:
Code:
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)>!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007