Musiwa said:
I am designing a long report that will span about
4 pages ( each record ). I am using the page
function to mark the beginning of each page ( it
is being designe as a single report). The problem
is the design view will not allow me to pass 22"
How can I increase the design sheet to allow me
to get to 48". I am using office 2003. Thankyou in
advance. I tried to change the y grid but it still
limits the detail veiw to 22".
The design space of each section in a report is limited to
22" and the total design space for the entire report is
limited to 200".
A common way around this is to make some/most of the text
boxes shorter and set their CanGrow to Yes so they expand
when formatted.
Another way is to create a group based on a constant
ecpression such as =1 and set the group's Header and Footer
to Yes. You can then spread the controls out over the
header, detail and footer sections.