Different size page footer on first page

[Susan]

I have a report that needs more fields in the footer on the first page than
on all consecutive pages. The total height of the footer on the first page
will be 1.5 inches, and the footer on all other pages will only be .5 inches.
The report has a header and enough room for one detail and a special page
footer on the first page, then a page header and four details and a page
footer on all other pages. The info in the footer on all other pages is also
the last line of the footer on the first page.

I've tried to set Visible to false for all the fields that only need to show
on the first page anytime the Page Number is not "1" in the Format property
of the Page Footer. This works as far as the data showing up....but it
leaves a 1 inch white space on all the other pages, and doesn't allow the
fourth detail to print. I can make the fields small with "Can Grow" set to
Yes, which makes all other pages correct...but the footer on the first page
runs off the bottom and doesn't show it all and it leaves a white space above
the footer and below the first detail.

I'm out of ideas....can anybody please tell me how to do this?
Thanks so much for any help!!
Susan

 

[Clifford Bass]

Hi Susan,

Try the reverse. Make the fields the sizes you want and set the footer
to the 1.5" height. Then set all of their Can Shrink values to Yes,
including the page footer's. On pages greater than 1 make sure their values
are all set to null; then they should shrink. Don't bother with the visible
setting unless you are using field borders.

Clifford Bass

 

[Rick Brandt]

Hi Susan,
Try the reverse. Make the fields the sizes you want and set the
footer
to the 1.5" height. Then set all of their Can Shrink values to Yes,
including the page footer's. On pages greater than 1 make sure their
values are all set to null; then they should shrink. Don't bother with
the visible setting unless you are using field borders.

PageFooters and PageHeaders do not support growing and shrinking. You
can fake a PageHeader with a GroupHeader based on a constant expression
(=1 for example) and set RepeatSection to True. This gives you something
that behaves like a PageHeader except that it can shrink/grow. There is
no work-around I know of for PageFooters.

 

[Clifford Bass]

Hi Rick,

My memory must be off. I forgot that they do not have those
properties. Thanks for the correction! But that does not mean you cannot
change the size of the page header or footer. It can be done manually by
setting the Height property in code. You have to use Twips, of which there
are 1440 per inch. I usually define a global constant in a regular module:

Public Const g_clngTwipsPerInch As Long = 1440

Then I can do this to set it to 1.5":

PageFooterSection.Height = g_clngTwipsPerInch * 1.5

When reading the code it is easier to see what is happening.

If she does set all of the text boxes that appear on the first page to
null on other pages, they should shrink up and the bottom most stuff should
move up. Then when the page footer section is resized manually to be
shorter, the bottom most stuff should still show. It may take some playing
around to get it to work, but is can be done. Sometimes you have to set the
page footer size while processing the page header. And when you print, it
may behave differently from when you preview.

Clifford Bass

 

[Marshall Barton]

If she does set all of the text boxes that appear on the first page to
null on other pages, they should shrink up and the bottom most stuff should
move up. Then when the page footer section is resized manually to be
shorter, the bottom most stuff should still show. It may take some playing
around to get it to work, but is can be done. Sometimes you have to set the
page footer size while processing the page header. And when you print, it
may behave differently from when you preview.

Individual controls may shrink, but nothing moves up/down
unless the section shrinks/grows.

If you are going to reduce the size of the page footer
section, it must be done in a page header event procedure.
You also must move any controls that would be below the new
bottom up (and maybe reduce their height) so they fit in the
new size.

 

[Clifford Bass]

Hi Marshall,

Not true, at least in 2007 where I just tested it. My memory about
having to do the stuff in the header's On Format event does fit my
memory--bad though it be today

Clifford Bass

 

[Marshall Barton]

I haven't got that far with A2007 yet, but it must be
significantly different in the way they layout pages to be
able to retreat from a page footer that is bigger than when
the page was first formatted. If they can do that, then it
should be a small step to allow page footers to grow like
other sections.