plh said:
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.
