Maximum Report Size

[Guest]

Is there a way to increase the maximum size of a created report within
Access? Access won't let me extend the height beyond 22" high. When I
manually change the setting withing the report properties, it won't allow me
to go any larger...

Any suggestions would be appreciated.

 

[Joseph Meehan]

Is there a way to increase the maximum size of a created report within
Access? Access won't let me extend the height beyond 22" high. When
I manually change the setting withing the report properties, it won't
allow me to go any larger...

Any suggestions would be appreciated.

I am going out on a limb, but I believe that is a printer driver
function and Access is just picking it up there.

 

[Douglas J. Steele]

I am going out on a limb, but I believe that is a printer driver
function and Access is just picking it up there.

Actually, no, it's a physical limitation of the Access Report object. From
the Help file (under Specification, Access):

Form or report width 22 in. (55.87 cm)
Section height 22 in. (55.87 cm)
Height of all sections plus section headers (in Design view) 200 in.
(508 cm)

One solution is to use subreports.