Output report to text file problem

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am using the command

DoCmd.OutputTo acOutputReport, "rptInvoices",
acFormatTXT, "zzz.txt", True

to create a .txt file from a single column report.

The report has no blank lines in it.

When I open the .txt file I get a blank line inserted
after each 4 data lines and 8 blank lines where a page
break would be in the report. Does anyone know how to
supress these blank lines?

Many thanks,

Steve
 
Hi Steve,

In addition to making sure that all vertical dimensions are multiples of
0.125 inch, try this:

- install the Windows Generic/Text only printer driver
- set all the fonts in the report to "Device Font 12 cpi"
- in Page setup, select a suitable paper size (e.g. Letter) and "cont.
feed - no break", and set the top and bottom margins to zero.
 
Back
Top