Problem With Report Export to Text File

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.

--
Duane Hookom
Microsoft Access MVP


"ItNeverWorks1stTime" wrote:

> 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.