<div>
Hi stephen55,<br />
<br />
try Output Format as RTF file OR HTML as both hold the Format well, unlike txt<br />
<br />
<br />
I hope this helps.<br />
<br />
jaffer
</div>


Hi stephen55,

try Output Format as RTF file OR HTML as both hold the Format well, unlike txt


I hope this helps.

jaffer

<div>
Thanks. I had to review the TransferText Actions, but this solved my blank line issue.
</div>


Thanks. I had to review the TransferText Actions, but this solved my blank line issue.

<div>
<div class="content wysiwyg-content">
I use the macro listed below to convert my report to a text file. The report (formatted correctly) is converted to a text file but spaces appear between some of the line items. The data is otherwise correct. &nbsp;What is causing the blank lines and how do I get rid of them without manually editing the *.txt file?<br />
<br />
My Macro<br />
<br />
Action: OutputTo<br />
<br />
Object type: Report<br />
Object name: <br />
Output Format: Text Files<br />
Output File:<br />
Auto Start:<br />
Template File:<br />
Encoding: &nbsp;( I have tried all the choices)
</div>
</div>


I use the macro listed below to convert my report to a text file. The report (formatted correctly) is converted to a text file but spaces appear between some of the line items. The data is otherwise correct.  What is causing the blank lines and how do I get rid of them without manually editing the *.txt file?

My Macro

Action: OutputTo

Object type: Report
Object name: 
Output Format: Text Files
Output File:
Auto Start:
Template File:
Encoding:  ( I have tried all the choices)

Text file created using OutputTo command has unwanted blank lines

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.