Export to RTF/HTML corrupts report

[Saul]

I'm running Access 2003 with Service Pack 3. I have a report with numerous
memo fields stacked vertically - with space between each field. When I view
the report within Access, it always looks fine. However, when I export the
report to RTF or HTML, the text from one memo field (typically taking up more
than two pages) is mingled with the label and text of the next memo field. Is
there a known problem with the "export" utility?

 

[MikeP125]

Saul,
Did you ever get help with this problem? I am having the same problem and it
is driving me crazy.
Thanks,
Mike

 

[Saul]

No, I have never received a response to this problem - and my company no
longer has a service agreement with Microsoft concerning Access 2003. For
what it's worth, I've confirmed that the problem still exists in Access 2007.
As near as I can tell, the problem is that the export facility is calculating
how much vertical space it should allocate to a memo field based on some
standard font (perhaps the "default" font specified in the Options dialog).
As you know, the problem is that if you aren't using this magic font, the
start of a subsequent field gets put in before the end of a previous field.

The only way I've been able t o work around this is to format all my memo
fields with 1 pt (yes, "one" point) font. Once the document is generated, I
run a macro that converts all the 1 pt. text back up to 9, 10, 11, or 12
point font as needed. Since I've done that, I haven't had the interleaving
problem.

 

[MikeP125]

Thanks for the info Saul, I really appreciate it. I will try and see if I can
use your sloution.
Thanks again.