Fit to page on print

[Alu_GK]

Hello -
access 2003. vista or XP.
I'm using a database to manage a reports.
the reports sould be a one page report, but if the fields are filled with
more information than expected than the one page becomes two pages, usually
it is due to 2-3 rows, not more.
How can a scale the print area to fit into one page no matter what ?
Thanks

 

[Fred]

"Print area" is defined by the paper size and the margins that you have
defined and ultimately ( if you make margins smaller and smaller) by the
portion of the page that the printer is able to print on.

Next you have to think about what your situation is. Your report, as your
have designed it, with your data that you want printed is bigger that one
page, as you have defined the page. That said, you have to think about
what you SPECIFICALLY want to happen in order to achieve your goal of a one
page report. A couple of answers might be:

Make the printable area of the page larger: (a small gain, but maybe enough)
Do this by setting the margins smaller.

Shrink the space requirements of your report/data so that it will fit on one
page: There are hundres of ways to do this, a few being Lots or ways to do
this, a smaller font, more efficient use of space, setting "can grow"
properties to "no" (if applicable, this would prevent some data from
printing), making unnecessarily large "boxes" smaller, etc.

Sincerely,

Fred

 

[Tom van Stiphout]

On Thu, 4 Dec 2008 03:07:06 -0800, Alu_GK

There is no built-in way to do that.

-Tom.
Microsoft Access MVP

 

[Alu_GK]

Thanks for your answers.
To know that there is no other way to do this (than the traditionaly
formating ways) is also important...
Thanks...