Can you print reports in Access with single line spacing?

H

herons96

I'm new to Access, but Page Setup doesn't seem to enable me to reduce line
spacing when printing reports.
 
F

fredg

I'm new to Access, but Page Setup doesn't seem to enable me to reduce line
spacing when printing reports.
Click to expand...

The size of the space between lines is determined...
1) By the size of the font used.
A larger font will have more empty space around it.

2) By the height of the control containing the text.
Make the height of the control thinner than a single line of text.
Then set it's Can Grow property to Yes.

3) By the empty space between each control.
Move each row of controls upward, to remove the space between them
(but do not let them overlap or touch)

4) By the height of the detail section (or whatever section the
control's are in).
Make the detail section just high enough to show the controls.
Set the Detail Can Grow to true also.
 
N

Neil

TO expand on Fred's reply a little,

You will need to open the report in 'Design View' and then adjust the things
that Fred mentions until your lines are spaced exactly as you want them.

HTH.

Neil
www.nwarwick.co.uk
 
G

George Nicholson

"Line spacing" is determined by the design of the report: the height of the
report's sections, its controls, and the vertical space between them.

For example, Sections have a property "Can Shrink". Setting this to Yes can
also close a vertical gap, in some cases.

Another example, if the data in your Detail section appears double spaced,
make sure the controls in that section are only as tall as they need to be
for their font size and that they hug the top of the section. Then drag the
bottom of the section up so that it hugs the bottom of those controls.

HTH,
 
Top