Report in design view

G

Guest

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

Marshall Barton

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top