Force One Record per Page

[Garret]

Hi,

I am using Access 2000.
I have a report that prints records based on a query, where it has
records from the main table, and under each record it shows all of the
corresponding child records to that record. (one-many relationship).

When I want to print the report it starts another record right after
all the last record's child records are finished. How do I only have
one record and its child records per page?

 

[Dirk Goldgar]

Hi,

I am using Access 2000.
I have a report that prints records based on a query, where it has
records from the main table, and under each record it shows all of the
corresponding child records to that record. (one-many relationship).

When I want to print the report it starts another record right after
all the last record's child records are finished. How do I only have
one record and its child records per page?

In the report's design view, open the proeprty sheet for the Group
Header section that corresponds to the main record. On the Format tab
of the property sheet, set the Force New Page property to "Before
Section".

 

[Garret]

In the report's design view, open the proeprty sheet for the Group
Header section that corresponds to the main record. On the Format tab
of the property sheet, set the Force New Page property to "Before
Section".

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thanks Dirk. Exactly what I wanted!