Line spacing in reports

Hi,

when building lists with reports, I would like to change the line spacing,
i.e. make it smaller than the minimum default.. A2k doesn't seem to let me
do this.

Is there a way make the line spacing smaller?

Wulff

The only way I can thing of to adjust the line spacing (I assume you mean
the space between each record in the detail section) is to adjust the "white
space" above and below the controls in the detail section. To do this, move
the controls closer to the top of the detail section then drag the bar at
the bottom of the detail section upward. You can't drag the bar over the
controls, just up to it, so if there is a control that you have shrunk down
to where it is not visible to you, it may block the bar from moving and you
may not be able to see why.

Also, make sure the controls aren't taller than you need to fit the text
that is in them. Be careful with this though because each video card is
slightly different. If you get the boxes too tight, although they may work
on your computer, they may not on another computer.

--
Wayne Morgan
MS Access MVP


"Wulf Wendelstein" wrote in message
...
Hi,

when building lists with reports, I would like to change the line spacing,
i.e. make it smaller than the minimum default.. A2k doesn't seem to let me
do this.

Is there a way make the line spacing smaller?

Wayne,

The only way I can thing of to adjust the line spacing (I assume you mean
the space between each record in the detail section) is to adjust the
"white
space" above and below the controls in the detail section.

Also, make sure the controls aren't taller than you need to fit the text
that is in them.

Thanks. But this is what I usually do. Problem is, there ist still a lot of
space between the lines of text, which on small labels sums up to a huge
amount of wasted space. Most of this waste results of the fact that the
space within the controls between the top of an uppercase letter and the
upper rim of the control is much bigger than needed, especially with text
sizes below 8 pt. Reducing the height of the control manually has only one
effect: It starts cutiing off the text line from bottom up instead of
keeping it symmetrically centered. So it seems to be not possible to reduce
line spacing below the amount given by the control height showing all of the
text line and a section height identical with the control ...?

Going from your description, without finding a different textbox control
somewhere, I think you've hit the limit.

--
Wayne Morgan
MS Access MVP


"Wulf Wendelstein" wrote in message
...
Wayne,

The only way I can thing of to adjust the line spacing (I assume you mean
the space between each record in the detail section) is to adjust the
"white
space" above and below the controls in the detail section.

Also, make sure the controls aren't taller than you need to fit the text
that is in them.

Thanks. But this is what I usually do. Problem is, there ist still a lot
of
space between the lines of text, which on small labels sums up to a huge
amount of wasted space. Most of this waste results of the fact that the
space within the controls between the top of an uppercase letter and the
upper rim of the control is much bigger than needed, especially with text
sizes below 8 pt. Reducing the height of the control manually has only one
effect: It starts cutiing off the text line from bottom up instead of
keeping it symmetrically centered. So it seems to be not possible to
reduce
line spacing below the amount given by the control height showing all of
the
text line and a section height identical with the control ...?

Another option Wayne would be to use the Print method of the Report
object to render the text programmatically. In this fashion the OP would
not be subject to any minimum margin props of the standard TextBox
control.

There's code on my site in the Report's section demonstrating the use of
the Print method.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Wayne Morgan" wrote in
message ...
Going from your description, without finding a different textbox
control
somewhere, I think you've hit the limit.

--
Wayne Morgan
MS Access MVP


"Wulf Wendelstein" wrote in message
...
Wayne,

The only way I can thing of to adjust the line spacing (I assume
you mean
the space between each record in the detail section) is to adjust
the
"white
space" above and below the controls in the detail section.

Also, make sure the controls aren't taller than you need to fit the
text
that is in them.

Thanks. But this is what I usually do. Problem is, there ist still a
lot
of
space between the lines of text, which on small labels sums up to a
huge
amount of wasted space. Most of this waste results of the fact that
the
space within the controls between the top of an uppercase letter and
the
upper rim of the control is much bigger than needed, especially with
text
sizes below 8 pt. Reducing the height of the control manually has
only one
effect: It starts cutiing off the text line from bottom up instead
of
keeping it symmetrically centered. So it seems to be not possible to
reduce
line spacing below the amount given by the control height showing
all of
the
text line and a section height identical with the control ...?