ADH97 - adhValueFromControl() - Size Limitation - WHY

[John McKee]

I'm attempting to use code developed by Getz et al in their Access97
Developer's Handbook to pass data
from an Access (2002) form to a Word (2002) template, and I've run into a
limitation.

One of text fields on my form contains data approaching 500 characters.
Actually, the text field holds data from
a memo field in the source table.

Only 255 characters are being passed from Access to Word, and I'm looking
for a work-around.

The procedure adhValueFromControl() uses a variant data type to hold the
data, and, I believe, there should
not be a limitation to 255 characters by a variant. So, why is the date
being truncated?

Any suggestions for a solution?

TIA,


John

 

[John McKee]

Sometimes just posting the question seems to get the juices flowing and an
answer presents itself.

The Caption property of a Label control can contain 2,048 characters. So, I
added a label to the form and set the Caption property to the value of the
text in the textbox in the forms Current Event.

Now the merge to the Word document contains all of the information.



Hope this helps someone else.



John