Group:  Microsoft Access ยป microsoft.public.access.reports
Thread: Different size page footer on first page

Geek News

Different size page footer on first page
Susan 12/31/2008 5:40:04 AM
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

RE: Different size page footer on first page
Clifford Bass 12/31/2008 6:21:01 AM
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

"Susan" wrote:

[Quoted Text]
> 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

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net