How do I change the space between lines in an Access report?

G

Guest

I need to get as many lines as possible on each report page - with readable
font size. The default spacing between lines is too large. How do I reduce it?
 
R

Rick Brandt

herb said:
I need to get as many lines as possible on each report page - with
readable font size. The default spacing between lines is too large.
How do I reduce it?

If you are talking about the line-spacing produced by TextBoxes that contain
multiple lines of Text you cannot reduce it as far as I know.
 
C

Chuck

If you are talking about the line-spacing produced by TextBoxes that contain
multiple lines of Text you cannot reduce it as far as I know.

If the text boxes only have one line each, Open the report in design view. Set
Can Grow property of all text boxes in the detail section to False. Position
all text boxes so that the top of one is just touching the bottom of the one
above.

Open report in preview mode. If there is still too much space between lines,
reduce the Height of all text boxes a small amount. Reposition all text boxes
so that they just touch each other again. Open report in preview. If space is
still to large, check to see if the 'tails' of letters like g, p, y are being
cut off. If not, repeat the reduce height of text boxes again.

Big Problem. The spacing in print preview may not be the same as the printed
document because each printer has its own minimum line spacing. Result can be
that the first few lines may print OK then there can be an empty line then a
few more lines printing OK. If this happens, then the only solution is to
increase the text box heights until the printed version does not have empty
lines.

Chuck
--
 

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

Top