access report formatting

  • Thread starter Thread starter dennis roberson
  • Start date Start date
D

dennis roberson

I am trying to adjust the "leading" in the output format
of an Access Database Report in order to squeeze a little
more information on the page without shrinking the font
size. I have the ability to adjust font size, but not the
space between lines ("leading"). There must be a default
spacing instruction somewhere. Does anyone know how or
where I can access that control in order to adjust the
spacing ("Leading") between lines in my report? Thanks
very much for your help. I have tried looking
everywhere. . .

Dennis Roberson
Fort Worth. Texas

(e-mail address removed)
 
Dennis,
Adjust the height of the controls to just the height
needed to print the tallest letters (l $%, etc.) and
the ones that drop below the line (g y j).
Then move each control up to just under the one above.
Take out any extra top and bottom detail section space.

I've found that using Ariel at 8 point, a control height
of 0.15" works. Larger font size or a different font will
require different height settings.

If you still think you need closer lines, all you can do then is to
concatenate all the fields into one control and print just that one control:
=[FieldA] & chr(13) & chr(10) & [FieldB] & chr(13) & chr(10) & etc.

The lines will print a shade closer this way then having controls one above
the other.
 
Back
Top