Report header size

[Guest]

I am writing a report with rather a large intoduction (which i have put in the Report Header) & other info at the end (in the footer). I have got to a point where Access will not let me drag the size of the report header any larger (about 56cms). Where can i increase this? Can i increase this?

 

[Cheryl Fischer]

Apparently not. A quick check in Access Help (topic: Specifications)
indicates that the maximum height of any report section is 55.87 cm.

If you will provide more detail about the controls, etc., in your report
header, it's possible that someone may offer design alternatives.



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I am writing a report with rather a large intoduction (which i have put in

the Report Header) & other info at the end (in the footer). I have got to a
point where Access will not let me drag the size of the report header any
larger (about 56cms). Where can i increase this? Can i increase this?

 

[estewart]

if go into the properties of the header and into the
events and in the OnFormat do vb code with
Me.PageHeaderSection.Height = 550

you can change the 550 to whatever you need - larger or
smaller

-----Original Message-----
I am writing a report with rather a large intoduction

(which i have put in the Report Header) & other info at
the end (in the footer). I have got to a point where
Access will not let me drag the size of the report header
any larger (about 56cms). Where can i increase this? Can i
increase this?

 

[Arvin Meyer]

I am writing a report with rather a large intoduction (which i have put in

the Report Header) & other info at the end (in the footer). I have got to a
point where Access will not let me drag the size of the report header any
larger (about 56cms). Where can i increase this? Can i increase this?

The maximum size of a section in a report is 22" (about 55.87 cm) You can
increase it, but you'll need to use a trick. The trick is to use subreports.
You can use a bunch of them I used as many as 12, but I suppose you could
use more. Just set the physical height to about 1/4" (6 mm) and the CanGrow
property of the subreport and the section to "Yes"

If you really want to get crazy, you can do the same trick by nesting
subreports inside of subreports (I've only done that 2 levels deep, but I
think you can go further)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access