subreport labels on next page

M

Mary Ann

I've created a report with 7 subreports. When the
subreport data goes to the next page, how do I repeat the
subreport label?

Thanks for your help.
 
M

Mary Ann

Thanks for the information. I'm still lost. I've inserted
the subreports in the detail section of a blank report.
I'm kinda new to Access, and don't understand your
explanation.

Thanks for your help.
 
M

Marshall Barton

Mary said:
Thanks for the information. I'm still lost. I've inserted
the subreports in the detail section of a blank report.
I'm kinda new to Access, and don't understand your
explanation.

Open the report in design view. The Sorting and Grouping
window is opened from the Virew menu. Enter =1 in the top
line under Field/Expression. In the lower part of the
window, enter Yes in the Header row.

Then go to the report design area and you'll see there is
now an =1 group header section. Put your labels there.

When the header section is selected, use the View menu to
display the Properties window. Look through the list of
properties and set Repeat Section to Yes. Save the report
and then test it.
--
Marsh
MVP [MS Access]

 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top