Output report to text file problem

[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

 

[Steve]

This may help, it supresses the blank lines in the detail
section but I still get 13 lines (or maybe 12 with 1
blank line before the first record on a page) when a page
break is encountered.

http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/Q
208/4/36.ASP&NoWebContent=1

 

[John Nurick]

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.