memo fields randomly truncated when exporting Access report to Wor

[Aurora85]

I have an Access report containing mostly memo fields. It is set up very
simply as such:
Label
Field

Label
Field
etc.
When I view or print the report in Access, it looks great, all the text is
there. When I export it to Word, however, some text gets cut off, seemingly
randomly. It is not a matter of field length; one comment may be many lines
long, and be all there, while the next comment might be only 2 lines long and
be cut off. It is not any certain field or record. I think it might have
something to do with how Word interprets the formatting of Access reports.
On a hunch, I increased the space between each field in the Access report.
This just caused different text comments to get truncated after exporting to
Word. Is this a glitch, or is there a fix? Help!

 

[Allen Browne]

See:
Memo Field That Is Exported to RTF Format May Be Truncated
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;288877

or:
When You Export an Access Report the Memo Field Is Truncated
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;281153

 

[aaron.kempf]

MDB is obsolete.

use ADP / SQL Server for everything you do.