Eliminate blank lines in access report export as text file

[Irshad]

I am exporting an access report as a text file. Because of
the pagesize (presently set to 'letter'), after about 50-
60 lines of data their is a blank line in the file. My
requirement is to eliminate these blank lines. What could
be done to achive this.

 

[John Spencer (MVP)]

Can you try exporting the underlying query instead of the report.

 

[Irshad]

I am unable to export the underlying query, as report
contains calculated fields and group summaries. Except for
the blank lines appearing as a result of page break,
everything else in the text file is perfect. In windows
2000 can we add a custom page size, if yes can you please
specify how? I guess that could help solve.

 

[John Spencer (MVP)]

Personnally, I know of no way to eliminate the blank lines if you export the
report. I believe I've seen solutions posted in the reports newsgroup that
suggest that you can do this by carefully setting up the font size and control
sizes. You might try searching the reports group in Google for a solution.

One method I might try using VBA
Export the report as you do now
Open the text document (in vba)
Open a blank text document
Step through each line of the export document and copy to new document if not blank
Close both documents
Delete the original document

 

[Greg Kraushaar]

Or once you have the Document open do a search and replace for two
Paragraph markers, and replace them with one. Repeat until Search
reports no finds.