Report header height differs based on page number

  • Thread starter Thread starter RobGMiller
  • Start date Start date
R

RobGMiller

Access 2003,

Need to change the height of the Report header for all pages after page 1.

This is to allow text on page 2 to show up below a background graphic.

So far I've tried changing the size of a text box based on page number in
the header group on format event. This seems to change the header size for
all pages.
 
Making a control visible or not depending on page number doesn't work either.

Once the header is expanded to the size of the control in it, the headers on
all the pages, including page 1 have the same size.
 
Another observation:

If a control exists above some text in the header and the control is
expanded the text doesn't push down to below the expanded control and
consequently it is not visible.

The position of the text controls can be modified on the page number by
changing the Top property in the header.onformat event . If the size of the
header section is not big enough the top property cannot be changed. If the
Header section size is expanded then it has the same size on Page 1.
 
Managed to get it working by making the header visible or not depending on
the page number.

That was too easy a solution for me I guess.

Thanks for giving me a place to share my experience.
 
I believe you are referring to the "Page" header, not the "Report" header
since a report header appears only once.

You can create a pseudo page header by creating a primary sorting and
grouping level on a constant expression like:
=1
View the Group Header for this level of grouping and set its Repeat Section
property to Yes. This will display this section at the top of every page. Use
this section as your Page Header.
 
Back
Top