legal size report

[Laurie]

Is there a way in Access 2003 to set the report size to legal?

 

[tina]

in the report's Design view, click File | Page Setup, click on the Page tab,
and in the Paper section of the dialog, set the Size option to Legal.

hth

 

[Laurie]

Thanks, Tina. Is there a way to do this using the Wizard for creating the
report instead of Design view? I have too many fields in my report and if I
change the report size after creating it all the fields still don't show up.

 

[tina]

Is there a way to do this using the Wizard for creating the

report instead of Design view?

well, i don't know, hon. try using the Wizard and see if it gives you any
options for paper size.

I have too many fields in my report and if I
change the report size after creating it all the fields still don't show

up.

not quite sure what you mean by that. legal size paper is - what? 11x14?
that means you have more "real estate" in Design view to work with,
subtracting the margins, of course. after changing the paper size, did you
resize the report in Design view to take advantage of the extra inches? and
by "fields", i assume you mean the controls in the report. are they being
cut off, or printed on a second page? or simply don't appear in Print
Preview at all? for more help, we'll need a more specific description of how
your report is set up, and what results you're seeing.

hth