repeat text if subreport spans multiple pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Odniel - 07 Dec 2005 17:49 GMT

I created a catalog in Access 2003. Data to the left of the page lists the
name of the product and it's main properties (dimensions, content, and
price). The subreport simply lists all the varieties of each product. How do
I repeat the product name or the word "continued" if the subreport data for a
product continues on the next page?

Reply to this Message

Duane Hookom - 08 Dec 2005 02:19 GMT

You can create pseudo page headers in subreport by creating a primary
sorting and grouping level on a constant like =1. View the Group Header for
this and place your controls in this section. Set the Repeat Section
property to Yes.

Signature

Duane Hookom
MS Access MVP
--

>I created a catalog in Access 2003. Data to the left of the page lists the
> name of the product and it's main properties (dimensions, content, and
[quoted text clipped - 3 lines]
> for a
> product continues on the next page?

Reply to this Message

Odniel - 08 Dec 2005 21:20 GMT

Sorry, I do not understand. I am new to Access. Where would I put the "=1"?
And where does the "continued" or the product name go in the subreport?

> You can create pseudo page headers in subreport by creating a primary
> sorting and grouping level on a constant like =1. View the Group Header for
[quoted text clipped - 8 lines]
> > for a
> > product continues on the next page?

Reply to this Message

Duane Hookom - 08 Dec 2005 22:20 GMT

View the sorting and grouping dialog in the subreport design view. Add a
primary level with a field/expression of:
=1
View the group header of this grouping level.

Signature

Duane Hookom
MS Access MVP
--

> Sorry, I do not understand. I am new to Access. Where would I put the
> "=1"?
[quoted text clipped - 15 lines]
>> > for a
>> > product continues on the next page?

Reply to this Message