Line Spacing on report export

[tomrector]

Access 2003
Exporting a report, from table, not query. (cant use "export" querry
because I require header line)

Select report, report screen looks fine no blank lines
Then select File , export
export as txt
header line prints OK, next line is first record prints OK
A blank line shows up after first record and then after every
third record
line height of header and detail lines are both 0.1677, font
size is 7 (report properties)

Does the same if I remove page header, does the same font size at
8,9,10,12.
Actually do not print file, it is for a csv data file. just don't
want blank lines.


Any help would be appreciated,

thanks
Tom Rector
(e-mail address removed)

 

[Duane Hookom]

I have successfully set the font to 6 points and the control and section
heights to 0.125" and set their Can Grow properties to No.

 

[tomrector]

Duane,
Changing the text to 6 and the height to .125 didn't make any
difference, Again the report "preview"looks normal, report printing is
normal, it is only when I "export" to a "txt" file that I get the
blank lines after every third record

 

[Duane Hookom]

2 out of 3 suggests doesn't make it with my solution. Did you also set all
controls and sections to not be able to grow? Do you have any blank vertical
space between controls or sections?

 

[tomrector]

Duane,
Yes all vertical space has been eliminated, all control formats
have been set to Grow=NO
I am sure it is in the "export process" and not the report process,
again when I print the report it prints just like shown, no blank
lines, but when I export it to a txt file it adds a blank line after
every third record.
Another hint is if I delete the page header, it still does the same
thing.

Tom

 

[Rick Brandt]

Duane,
Yes all vertical space has been eliminated, all control formats
have been set to Grow=NO
I am sure it is in the "export process" and not the report process,
again when I print the report it prints just like shown, no blank
lines, but when I export it to a txt file it adds a blank line after
every third record.
Another hint is if I delete the page header, it still does the same
thing.

Known issue. See this Microsoft article...

http://support.microsoft.com/default.aspx/kb/208436/en-us

 

[tomrector]

Thanks Rick,
It apperas to work correctly now,

Known issue. See this Microsoft article...

http://support.microsoft.com/default.aspx/kb/208436/en-us