Line Spacing on report export

T

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)
 
G

Guest

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

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
 
G

Guest

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?
 
T

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
 
R

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.
Click to expand...

Known issue. See this Microsoft article...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extra blank line on report 1
Access 2007 Report Export To TXT Line Wrapping... 2
Export Report Automated 2
Line drawing on report 0
A2003 report to CSV file 4
Problem With Report Export to Text File 2
Formatting Data 1
Unwanted spaces between records (lines) on report 3

Top