Change report size

[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

 

[John Spencer]

None that I know of.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Marshall Barton]

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?

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.

 

[Regi]

Thanks, I was afraid that would be my answer.

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.