Maximum Height of page

[Marjaneh]

Hi!
In a report, I would like to design 3 page report but the software wouldn't
allow me to increase the height of the page (in Detail) more than 22". How
could I increase it to for example 25"?

Thanks,
Marjaneh

 

[Al Campagna]

Marjaneh,
No... 22" is the max. That refers to the design length.
You'll need to use subreports to fit all the data into the design. SubReports only
take up a small amount of "design" space, and by using CanGrow, they will expand on
printing to show all the data.
Break your data up into say... into 3 individual reports, and combine them into one
master report, with those 3 reports each in their own subreport of the master.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Marjaneh]

Al Campagna,

Thanks. I'll do it.

Marjaneh

Marjaneh,
No... 22" is the max. That refers to the design length.
You'll need to use subreports to fit all the data into the design. SubReports only
take up a small amount of "design" space, and by using CanGrow, they will expand on
printing to show all the data.
Break your data up into say... into 3 individual reports, and combine them into one
master report, with those 3 reports each in their own subreport of the master.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[John Spencer]

Another method that can be used is to add a group based on the primary
key of the table used in the detail section. This will allow you to add
a Group header and group footer to the report (and these can each be up
to 22 inches in height) thereby giving you up to 66 inches for the
details of your report.


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Marjaneh]

Thank you for your replays. It all worked. I used both method and I think the
easiest way is the Subreport because the header and footer workes for all of
them.

Best regards,
Marjaneh