Office Links

[Question Boy]

Hello,

I have a simple report which has a field which come from a memo field. In
the report all is good. All the data appear. However, when i use the
OfficeLinks,
'Analyze it with Microsoft Office Excel' and it does the transfer, the memo
field gets truncated. Why? Is there a simple fix or do I need to perform an
export on the underlying query?

Thank you,

QB

 

[Tom Wickerath]

Hi QB,

Yes, you will need to export the underlying query:

Memo field is truncated when you output a report to excel
http://support.microsoft.com/kb/294286

While the title of this article includes "in Access 2002", it applies to
other versions as well. I cannot recommend the Method 2 fix.


Tom Wickerath
Microsoft Access MVP
_____________________________________________


Hello,

I have a simple report which has a field which come from a memo field. In
the report all is good. All the data appear. However, when i use the
OfficeLinks,
'Analyze it with Microsoft Office Excel' and it does the transfer, the memo
field gets truncated. Why? Is there a simple fix or do I need to perform
an
export on the underlying query?

Thank you,

QB