Equivalent for clipboard.gettext needed

C

Charles

Am using the following code to do a paste append from one form to another.
It is attached to a button. The clipboard.gettext is from VB, but doesn't
appear to work in VBA.

Any ideas?

Thanks!

Function frmmcrPasteNotesAppendToCSRText()
On Error GoTo frmmcrPasteNotesAppendToCSRText_Err

csrtext.setfocus
csrtext.text = csrtext & vbcrlf & clipboard.gettext


frmmcrPasteNotesAppendToCSRText_Exit:
Exit Function

frmmcrPasteNotesAppendToCSRText_Err:
MsgBox Error$
Resume frmmcrPasteNotesAppendToCSRText_Exit

End Function
 
D

Dirk Goldgar

"Charles" <CUdell(reversetheloatoaolandremovebetweenparens)@loa.com>
wrote in message
Am using the following code to do a paste append from one form to
another. It is attached to a button. The clipboard.gettext is from
VB, but doesn't appear to work in VBA.
Click to expand...

There's no Clipboard object in Access. TTBOMK, you have to call the
Windows API directly to get data from the clipboard. The following link
has a module by Terry Kreft containing the definitions and functions to
do that:

http://www.mvps.org/access/api/api0049.htm
API: Copy variables/control contents to memory
 
Top