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

Asked By her on 24-Sep-07 09:42 PM
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?


Rick Brandt replied on 24-Sep-07 10:12 PM
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com
Chuck replied on 25-Sep-07 08:41 AM
On Tue, 25 Sep 2007 02:12:54 GMT, "Rick Brandt" <rickbrandt2@hotmail.com>


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