Eliminating page break blank lines when exporting to Text file

[dgilbert]

Hi,

I'm producing a report that I end up exporting as a Text file for use as input with another program.

I have 99% of my formatting issues licked, except for the BLANK LINE which is introduced into the Text file as a result of the page breaks in the report. These aren't page breaks between sections -- I only have a single row in the "Detail" section -- but are the actual page breaks caused by the report spanning several pages.

Is there a way to eliminate these page breaks when exporting to a Text file? This isn't a show-stopper, as the other program will ignore blank lines, but I'm soooooo close to having exactly what I want!

Thanks for any replies,

-- Dan

 

[flaniganmj]

How is your the data pulled into the report?

Can you not use DoCmd.TransferText on a query?

 

[dgilbert]

Thanks for your suggestion.

I'll take a look at TransferText to see if I can use it to accomplish what I need.

-- Dan