Problem With Report Export to Text File

[ItNeverWorks1stTime]

I have created a report that needs to be exported to a Text File.

Everything looks good on screen and when the report is printed as an Access
report, but when I export to a Text File extra line breaks are inserted after
every 2nd or 3rd line of the Detail section.

In trying to resolve the problem, I have stripped down the complexity of the
detail to a simple Unbound Text Box containing a single 4digit element and
still the output to a Text File inserts extra linebreaks after 2 or 3 lines.

If I increase the Height of the Detail section from the minimum (which is
what I require) I get more lines appear on the Text File, perhaps 7 or 8
before an erroneous extra line is inserted.

Any ideas, it has been frustrating me for days trying to resolve this problem.

 

[Duane Hookom]

What I have done in the past is to set the fonts in the detail section to
quite small (try 6 or 7 point). Set the text boxes and detail height as small
as possible and don't allow them to grow. Then try your export to text.

 

[Mark Andrews]

You could always resort to building the text file via code (running through
the query that drives your report etc...).

Mark