Maximum Report Detail Height

[Joe]

Help!

My customer wants to generate a long report from the
database. It is a legal-type of document and is 8 pages in length.
It is a combination of text and subreports.

Development was going fine until I got about halfway through
the third page and realized that I could not move the report detail
height to anything larger than 22". I tried changing it on the
properties page and Access gives me a message "This number is too
large".

What do I do? Tell my customer that Access can only print
reports that are 3.5 pages in length? I hope not.

Can anyone help me crack the 22" barrier?

J

 

[Ken Snell \(MVP\)]

Help!

My customer wants to generate a long report from the
database. It is a legal-type of document and is 8 pages in length.
It is a combination of text and subreports.

Development was going fine until I got about halfway through
the third page and realized that I could not move the report detail
height to anything larger than 22". I tried changing it on the
properties page and Access gives me a message "This number is too
large".

What do I do? Tell my customer that Access can only print
reports that are 3.5 pages in length? I hope not.

Can anyone help me crack the 22" barrier?

No. ACCESS' design limitation is that 22 inches is the maximum height for
any section in a form or in a report.

But, you may be able to make your setup work in a different way. Set the
Detail section's CanGrow property to Yes. Set all the textbox and subreport
controls' CanGrow property to Yes. Make the height of each of the textbox
and subreport controls be just 0.5 inch. That likely will let you design the
report to contain all the items that you want, and the CanGrow properties
will let ACCESS print a longer report than 22 inches.