Change report size

  • Thread starter Thread starter Regi
  • Start date Start date
R

Regi

I have a report that was on 8 1/2 x 14 paper. Now i need to print it out on
11 x 17 paper. I went into Page set up and changed the paper size. Is there
any easy way to spread the data across the report other than manaully moving
each column?

Thanks, Regi
 
None that I know of.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Regi said:
I have a report that was on 8 1/2 x 14 paper. Now i need to print it out on
11 x 17 paper. I went into Page set up and changed the paper size. Is there
any easy way to spread the data across the report other than manaully moving
each column?
Click to expand...


If you have to do this frequently (and I can not imagine a
reason for it) or if you have to do this for a lot of
reports, you could create a design time wizard like Sub
procedure to do it.

OTOH, most likely you will want to adjust the size and
position of some/many/most controls and for a one time
change, it would be quicker/easier to just do it manually.
 
Thanks, I was afraid that would be my answer. :)

Marshall Barton said:
If you have to do this frequently (and I can not imagine a
reason for it) or if you have to do this for a lot of
reports, you could create a design time wizard like Sub
procedure to do it.

OTOH, most likely you will want to adjust the size and
position of some/many/most controls and for a one time
change, it would be quicker/easier to just do it manually.
Click to expand...
 
Back
Top