Carriage returns in exported text file

[john123allen]

Novice Access user. I have a long Report of 200 lines and 30 to 40
characters each line, pulled from a complex query. When I export it to
a text file for a required EDI transmission there are unwanted
carriage returns in the text file. I do not use the Wizard and it
cannot be and is not a delimited or fixed length file. I run my
report. It looks fine. Go to file. Click export. Save as type. Click
text file. Open the text file and there are carriage returns every 5
to 6 lines. There are no carriage returns appearing in the report
before it is exported to the text file.

 

[MH]

Export the query, not the report.

MH

 

[john123allen]

Export the query, not the report.

MH

The Report massages the data into the correct format to transfer in a
flat text file to make EDI transmisssion to my customer. All is good
except the blank lines caused by the unwanted carraige returns.
Direct from the Query would not look the same and would not be
accepted by their system.

 

[John Nurick]

Hi John,

As far as I can remember the way to fix this is to ensure that _all_ the
vertical dimensions in the report are exact multiples of 1/8 inch. It
may also help to install the Windows Generic/Text Only printer driver
and use this when designing the report; and/or set all the text in the
report to 12 point Courier New or other monospaced font.

 

[john123allen]

Hi John,

As far as I can remember the way to fix this is to ensure that _all_ the
vertical dimensions in the report are exact multiples of 1/8 inch. It
may also help to install the Windows Generic/Text Only printer driver
and use this when designing the report; and/or set all the text in the
report to 12 point Courier New or other monospaced font.

John,

Thank you very much. That solved the problem.

John Allen