Hi Dwayne,
As for exporting an Access 2002 report into RFT format (Word) the memo
field is not exported/ runcated; we can try to change the printer to a
Generic/ Text Only printer to resovle the issue; Please perform the
following steps:
1. Click Start, Settings and then Printers.
2. Click "Add Printer" to bring up the Add Printer Wizard.
3. Select "Local Printer" and then click Next.
4. In the Manufacturers list, click Generic.
5. In the Make/Model or Printers list, click Generic / Text Only, and then
click Next to complete the Wizard.
6. Set the "Generic/Text only" printer as the default printer.
7. Open the database and then preview the report.
8. Export the report to .rtf file.
9. Check the .rtf file and note that there is no truncation occurred in the
output file.
10. Change the default printer to your original printer.
Please feel free to reply to the threads if you have any concerns or
questions.
Sincerely,
Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <
www.microsoft.com/security>
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Dwayne Conyers" <
[email protected]>
|
| Sorry, there was a typo. The article is:
|
| Knowledge Base
|
| ACC2000: When You Export an Access Report the Memo Field
| Is Truncated
|
| PSS ID Number: 281153
|
| Article Last Modified on 12/16/2003
|
| This article was previously published under Q281153
|
| The symptoms here are truncation of a memo field. This
| was part of our problem... but extended beyond this.
|
| We have sort of a workaround where we replace the page
| header and footer with report header and footer.
|
| This means we can't import the page numbering that we
| wanted at the bottom but we do have a non-repeating
| header, so that is acceptable.
|
| We can't seem to have page numbering... it blows up in
| page footer and in report footer... so if there are any
| other workarounds we'd be willing to try.
|
| For the record, HTML also had the same results and it
| seems to be an issue of not using page hdr/ftr and not
| using a report ftr.
|
|
| >-----Original Message-----
| >"Dwayne Conyers" wrote
| >
| > > Checked MSDN for any tips and saw reference
| > > to Knowledge Base PSS ID Number: 2881153
| > > but this seems to only apply to Access 2000 --
| > > we have Access 2002 SP-2. However, this
| > > seems to be the same issue we were dealing with
| > > previously.
| >
| >I didn't get any results searching either the Knowledge
| Base nor MSDN on
| >"2881153" -- could there have been a typo in entering it
| here? Just because
| >the article has not been updated to indicate 2002 doesn't
| mean that it _does
| >not apply_.
| >
| >There have been reports of formatting problems in saving
| to RTF (Rich Text
| >Format, which is used in exporting to Word). Some, like
| yours, are more
| >drastic than what I have encoutered personally.
| >
| >Was there a workaround, or a fix, indicated in that
| article? I would guess
| >that if there was, you'd have tried it, and as we are
| still pursuing this,
| >that it did not work.
| >
| >So, I think the next step is to look for alternatives. I
| have had better
| >luck saving Reports as HTML pages, although graphics are
| still omitted and I
| >have seen minor, truly minor, formatting differences.
| >
| >I'm not aware of a report stylesheet for XML, but I can't
| recall that I have
| >exported a _report_ as XML. Worked nicely for Tables...
| in and out, but I
| >didn't have non-Access software to try to use the XML
| tables, when I tested
| >it.
| >
| >If you find that 2881153 is in error, please post back to
| clarify.
| >
| > Larry Linson
| > Microsoft Access MVP
| >
| >
| >.
| >
|
