Page Headers in Subreports

  • Thread starter Thread starter RJF
  • Start date Start date
RJF said:
Is there any way to force a page header on a sub-report to display
in the main report?
Click to expand...

You can simulate it with a repeating group header.

1. Open the subreport in design view.

2. Open the Sorting And Grouping box (View menu.)

3. As the top row, insert an expression that won't change, e.g.:
=0

4. Below this, set Group Header to Yes.
Access adds a new group header to the report.

5. Select the new group header, and set its Repeat Section property to Yes.

The new section now repeats at the top of each page.
 
No page headers and footers are controlled by the main report.

What you can do is
-- add a top-level group to the sub-report
-- set the field to =1 (or any constant)
-- close the Sorting and grouping dialog
-- Copy the Page header controls into the group
-- Set the Group's Repeat Section property to True (Yes)


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Hi John,

Another genius! That was the same answer I got from Allen and it works great.

Thank you very much and also thank you for your quick response.
 
Back
Top