Hi All,
I have a text box at the bottom of the page header. The text box's
"can grow" property is set to yes, but the page header prevents it
from growing. Changing page header property to "Auto Height" to yes
does not do it. Is there some way to make this happen?
Thanx,
-plh

"plh" <(E-Mail Removed)> wrote

> I have a text box at the bottom of the page
> header. The text box's "can grow" property
> is set to yes, but the page header prevents it
> from growing. Changing page header property
> to "Auto Height" to yes does not do it. Is
> there some way to make this happen?

The property you desire is "Can Grow" for the Section, which in Classic
Access (2003 and earlier) Reports is available in the Header and Footer
Sections for Report, Group, and in the Detail Section. I presume (it's only
my guess) that it was omitted from the Page Header and Page Footer because
they are not "data connected" but "report format connected".

Given that is the situation, are you sure there isn't some alternative to
using a CanGrow Control in the Page Header? The way I tested this, I had to
write VBA code to store (arbitrary) text in a Can Grow Control to accomplish
the test (and I set the value of the Control in the Format event of the
PageHeaderSection).

You can set the Height property of the PageHeaderSection, in code, if you
keep elsewhere the original size of the PageHeaderSection less the Height of
your CanGrow Control. It will take some concentration and care in getting
all the nomenclature correct, and using VBA code in the Format and Print
events of the PageHeaderSection. I validated that it could be done, using a
sample report framework, and it was neither as intuitive, nor as simple, as
I'd hoped it would be.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access