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