expanding report to fit page on print

[Guest]

I have a report paginated by week where each week's data needs to print on
one single page. I have had to adjust the font and position of the detail
lines to accommodate the maximum number of lines, but where there are far
fewer lines it is obviously far smaller than necessary and does not allow for
space to write between the groups. Is there a way to dynamically resize the
print to fit the page (like in Excel)?

 

[Larry Linson]

I have a report paginated by week where each week's data needs to print on
one single page. I have had to adjust the font and position of the detail
lines to accommodate the maximum number of lines, but where there are far
fewer lines it is obviously far smaller than necessary and does not allow
for
space to write between the groups. Is there a way to dynamically resize
the
print to fit the page (like in Excel)?

No, Access does not have the "fit to page" option (at least through Access
2003; I haven't done enough with Access 2007 to say about it). Sorry.

Larry Linson
Microsoft Access MVP