How change Report's PageHeader Height programatically in PageHeaderSection_Format?

[paul.schrum]

Developing in Access 2007 to extend a 2003 .mdb file.

I would like to change the Height of the PageHeader of a report
depening on whether or not it is Page = 1.

But the Object Browser says Report.PageHeader is type Byte, so there
is no .PageHeader.Height or anything else.

Further, when I say

Dim i as Integer
i = [Report_MyReport].PageHeader

i = 0.

This is when I am in Private Sub PageHeaderSection_Format(Cancel As
Integer, FormatCount As Integer)

Is there any way I can do what I need to do, change the Page Header
size programatically?

Thanks in advance for all help.

- Paul Schrum
Raleigh, NC

 

[Marshall Barton]

Developing in Access 2007 to extend a 2003 .mdb file.

I would like to change the Height of the PageHeader of a report
depening on whether or not it is Page = 1.

But the Object Browser says Report.PageHeader is type Byte, so there
is no .PageHeader.Height or anything else.

Further, when I say

Dim i as Integer
i = [Report_MyReport].PageHeader

i = 0.

This is when I am in Private Sub PageHeaderSection_Format(Cancel As
Integer, FormatCount As Integer)

Is there any way I can do what I need to do, change the Page Header
size programatically?

The default name of the page header section is
PageHeaderSection, so you should be using:
Me.PageHeaderSection.Height
or
Me.Section(1).Height

 

[paul.schrum]

Marshall,

Thank you very much.

- Paul