Question Compatibility issue between Access 2003 and Access 2007?

[Al Oberneder]

I wrote VBA code that copies text that I have highlighted within a field (called "Description) in one form (Form A) and pastes it into a field by the same name but in a different form (Form B). When pasting it, it also adds a date stamp.

The VBA code I wrote is as follows:

'Declare global variable to hold the text I want to copy/paste.
Global GloMtgText As String

'Copy selected text from the Description field in Form A. (This code is attached to the Lost Focus event).
GloMtgText = "(" & Me.DateCompleted & ") " & Me.Description.SelText

'Append the text into the Description field in Form B. (This code is attached to the On Click event).
Me.Description = GloMtgText & Me.Description

This code works just fine in MS Access 2003. I can copy a rather large string from one field to the other. However, in MS Access 2007 the pasted text is truncated at about 155 characters. I am baffled! Can anyone help me? Is there a string limitation in MS Access 2007?

Thank you very much for your help!

 

[vbaInet]

Please avoid double posting.