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 wrote:
> 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

Regi wrote:

>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.

-- 
Marsh
MVP [MS Access]

Thanks, I was afraid that would be my answer. :) 

"Marshall Barton" wrote:

> Regi wrote:
> 
> >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.
> 
> -- 
> Marsh
> MVP [MS Access]
> .
>