Problem With Report Export to Text File

  • Thread starter Thread starter ItNeverWorks1stTime
  • Start date Start date
I

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.
 
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.
 
You could always resort to building the text file via code (running through
the query that drives your report etc...).

Mark
 
Back
Top