copy variable to clipboard

  • Thread starter Thread starter Terry Holland
  • Start date Start date
T

Terry Holland

Im struggling with a seemingly simple task. I want to implement a Copy
function in an application that will compile a the fields of a record into
a variable and them place this variable onto windows clipboard. ie
something like this

Sub CopyRecord

Dim strClipboard As String

strClipboard = Me.task_lng_id & vbTab
strClipboard = strClipboard & Me.txttask_dte_logged & vbTab
strClipboard = strClipboard & Me.txttask_txt_title & vbTab
strClipboard = strClipboard & Me.txttask_txt_description & vbTab
strClipboard = strClipboard & Me.txttask_mem_notes & vbTab

DoCmd.CopyToWindowsClipboard strClipboard

End Function

could someone tell me how to do this as I cant find a function similar to
CopyToWindowsClipboard


tia

Terry Holland
 
Back
Top