If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fit to page on print
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 -- Alu_GK |
#2
|
|||
|
|||
Fit to page on print
"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 |
#3
|
|||
|
|||
Fit to page on print
On Thu, 4 Dec 2008 03:07:06 -0800, Alu_GK
wrote: There is no built-in way to do that. -Tom. Microsoft Access MVP 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 |
#4
|
|||
|
|||
Fit to page on print
Thanks for your answers.
To know that there is no other way to do this (than the traditionaly formating ways) is also important... Thanks... -- Alu_GK "Tom van Stiphout" wrote: On Thu, 4 Dec 2008 03:07:06 -0800, Alu_GK wrote: There is no built-in way to do that. -Tom. Microsoft Access MVP 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 |
Thread Tools | |
Display Modes | |
|
|