.PutInClipboard question

[batteam]

I am using the ...SetText / .PutInClipboard code as follows:
With myobj
Set myobj = New MSForms.DataObject
myobj.SetText varReasonFinalText
myobj.PutInClipboard
myobj.Clear
End With

..in an Access 2007 project behind an Access form. It works great, as long as the text I cut and paste is 255 characters or less. My problem is, some text fields I need to cut and paste are greater that 255 characters in length. The result is that all text beyond that limit is cut off. I have not been able to find out what, if any, a parameter would be that would increase the size allowed for this function. Any help on how I can use this code to cut and paste fields larger that 255 characters would be appreciated. Thanks.

 

[strongm]

Erm ... I'm not aware of any such limitation in the DataObject, nor can I replicate the problem you describe. Be aware, however, that the IDE's Locals window has display limitations that may give the impression that strings are truncated to 255 characters (they are not, but the Locals window will only display the first 255 chars)