memo fields output to text file

[Guest]

Access 2000
I'm trying to output a report containing a memo field to a text file using
the command:

DoCmd.OutputTo acOutputReport, "reportname", acFormatTXT, "C:\textfile.txt"

The full memo field is displayed if I preview the report but in the
resulting .txt file, the last line of the memo is sometimes missing. There
appears to be no pattern to which memos are being truncated and it does not
matter how long the memo is.

Has anyone any experience of this or a solution/work around?

 

[John Nurick]

Hi Theorea,

Problems often arise when outputting/exporting a report to a text file
because the formatting of the text and other stuff on the report has to
be reconciled with the limited possibilties of plain text.

It helps if you ensure that all the vertical dimensions of the sections
and controls are exact multiples of 0.125 inch and that all the text is
in a monospaced font such as Courier New. For best results, install and
select the Windows "generic/plain text" printer driver and format the
report so it previews satisfactorily with that.