If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Export to RTF/HTML corrupts report
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? |
#2
|
|||
|
|||
Export to RTF/HTML corrupts report
Saul,
Did you ever get help with this problem? I am having the same problem and it is driving me crazy. Thanks, Mike "Saul" wrote: 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? |
#3
|
|||
|
|||
Export to RTF/HTML corrupts report
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" wrote: Saul, Did you ever get help with this problem? I am having the same problem and it is driving me crazy. Thanks, Mike "Saul" wrote: 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? |
#4
|
|||
|
|||
Export to RTF/HTML corrupts report
Thanks for the info Saul, I really appreciate it. I will try and see if I can
use your sloution. Thanks again. "Saul" wrote: 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" wrote: Saul, Did you ever get help with this problem? I am having the same problem and it is driving me crazy. Thanks, Mike "Saul" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|