Page Header resizing

I have a report where the page header is not resizing (not shrinking) when
fields are null even though the fields (mostly text fields) are set to
shrink = yes. I have set the Auto Height property to yes. What am I missing?

On Mon, 10 Aug 2009 18:03:40 -0700, Jay Oken wrote:

I have a report where the page header is not resizing (not shrinking) when
fields are null even though the fields (mostly text fields) are set to
shrink = yes. I have set the Auto Height property to yes. What am I missing?

Sometimes the Help files can be helpful ... if you use them.
***
The CanShrink property does not apply to form or report page header
and page footer sections, although it does apply to controls in such
sections.
***
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Understood. So.....is there a way to shrink the size of the page header?


"fredg" wrote in message
.. .
On Mon, 10 Aug 2009 18:03:40 -0700, Jay Oken wrote:

I have a report where the page header is not resizing (not shrinking)
when
fields are null even though the fields (mostly text fields) are set to
shrink = yes. I have set the Auto Height property to yes. What am I
missing?

Sometimes the Help files can be helpful ... if you use them.
***
The CanShrink property does not apply to form or report page header
and page footer sections, although it does apply to controls in such
sections.
***
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

No, you can't shrink a Page Header Section. You can make it invisible but the
space isn't recouped.

Maybe, you could provide your requirements/needs someone could suggest an
alternative. A pseudo page header can be created with a top level sorting and
grouping level on a constant expression like:
=1
This section can grow or shrink.
--
Duane Hookom
Microsoft Access MVP


"Jay Oken" wrote:

Understood. So.....is there a way to shrink the size of the page header?


"fredg" wrote in message
.. .
On Mon, 10 Aug 2009 18:03:40 -0700, Jay Oken wrote:

I have a report where the page header is not resizing (not shrinking)
when
fields are null even though the fields (mostly text fields) are set to
shrink = yes. I have set the Auto Height property to yes. What am I
missing?

Sometimes the Help files can be helpful ... if you use them.
***
The CanShrink property does not apply to form or report page header
and page footer sections, although it does apply to controls in such
sections.
***
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail