acformattxt vertical spacing issues when opening with MS WORD/NOTE

[Guest]

I'm using MS Access 2000 and designing a form that will be send out to a file
using:

DoCmd.OutputTo acOutputReport, "Report1", acFormatTXT, "Report1.txt", True

The report output looks good, no strange vertical spacing, etc. The design
view preview is also right on the money. The problem appears to be in MS
Word or Notepad. It seems to open the report and spills the first page onto
a second. Now if I try to output to acFormatRTF and bring it into MS WORD or
MS WORDPAD it looks great.

The bottom line is I'm trying to get a report that can be imported into just
about any viewer by making the report a fixed pitch font, using 80 char.
accross, etc.

Can anyone shed some light on the problem?

 

[Brian]

I'm using MS Access 2000 and designing a form that will be send out to a file
using:

DoCmd.OutputTo acOutputReport, "Report1", acFormatTXT, "Report1.txt", True

The report output looks good, no strange vertical spacing, etc. The design
view preview is also right on the money. The problem appears to be in MS
Word or Notepad. It seems to open the report and spills the first page onto
a second. Now if I try to output to acFormatRTF and bring it into MS WORD or
MS WORDPAD it looks great.

The bottom line is I'm trying to get a report that can be imported into just
about any viewer by making the report a fixed pitch font, using 80 char.
accross, etc.

Can anyone shed some light on the problem?

No, I can't throw any light on your particular problem, but you could search
the web for a great little product called Win2pdf, which allows you to save
anything as a PDF file. It only costs about $30, you can try before you
buy, and I can tell you from my own experience that it works.

OK, a PDF file can't be read by ANY reader, but who cares? Everyone has got
(or can get, for free) Acrobat Reader.

 

[T Martin]

There is also a free pdf write called CutePDF Writer