Page Header Re-Sizing

[Dave Ruhl]

Access 2002 Report Design: The Page Header section
doesn't have the 'Can Grow' property like other
sections. My problem is that I have a textbox obect (the
report title) which is set to 'Can Grow = Yes' to allow
for extra long titles. When this textbox expands to two
lines it covers the label fields (my column headers)
below it, instead of forcing them lower on the page. Is
there any solution to this ???

Thanks.

 

[Duane Hookom]

Add a new, primary sorting and grouping level and set the field/expression
to a constant value like:
=1
Set it display header to Yes. Set this =1 group header Repeat Section
property to Yes. Use this section as a page header.

 

[Dave Ruhl]

Thanks for the tip Duane, I will give it a try. Although
whenever I have tried to repeat a group header in the
past, my reports take 10x longer to run, so I usually try
to avoid that 'feature'.

 

[Duane Hookom]

I haven't really noticed this issue. Usually Page of Pages may slow a
report.