Generating report in Access

[Yue Zhao]

Is there a limit of length of the report? I can't make it longer than 21
inch...

 

[Jeff Boyce]

You have paper longer than 21 inches? Are you trying to fit everything on
one "page"?

You should be able to use as many pages as you need to fit it all in.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Yue Zhao]

No. I have been breaking the report into pages of letter size, using the
page break. But the "detail" part of the report can't be enlarged any
more after 21 inches.
Is there any suggestion about that?

 

[Douglas J. Steele]

It's a hard-and-fast limit. You can get around some of the length issues
using subreports, but you're pretty much stuck for width.

 

[John W. Vinson]

Is there a limit of length of the report? I can't make it longer than 21
inch...

The limit (including margins, I believe) is in fact 22 inches. I believe you
can stretch it some by using Subreports.

John W. Vinson [MVP]

 

[Larry Linson]

The limit (including margins, I believe) is in fact 22
inches. I believe you can stretch it some by using
Subreports.

But, to the original poster... you can put more information than a human can
grasp into a 22" X 22" space. It would appear to me that you have a problem
in how your data itself is structured, or how your presentation of the data
is structured.

Years ago, in another incarnation, I was supporting a Project Management
Software package. One of our Sales Tech Support people sent us a question
from his customer: "Can the product support a project of 400,000 tasks?" My
response was, "No, the product limited to 32,767 tasks, but 32,767 is more
tasks than a human could grasp, follow, and understand. However, the
product has very nice features for breaking down into groups or subprojects
that a project manager can grasp, and consolidating the results into an
overview that corporate management can grasp and understand."

I suspect a similar answer may apply here.

Larry Linson
Microsoft Access MVP