How do I keep a report from going to a new page for each record?

[Cindy]

I have a form that needs to be printed and it takes up
the whole page. I would like to keep the report from
advancing to a new page with every record until it gets
to a new person (Put Mr. Smith's 3 records on this form,
then when Mr. Jones info comes up, start a new form and
put all his info on that form, etc.)

Thanks

 

[fredg]

I have a form that needs to be printed and it takes up
the whole page. I would like to keep the report from
advancing to a new page with every record until it gets
to a new person (Put Mr. Smith's 3 records on this form,
then when Mr. Jones info comes up, start a new form and
put all his info on that form, etc.)

Thanks

I'll assume you are interchanging the words form and report and it is
a report you are printing, not a form.

Open the report in Design View.
Click on View + Sorting and Grouping
Enter the [PersonsName] field in the upper left panel.
In the lower panel enter Yes for Group Header.

Set the Group Header's ForceNewPage property to Before Section.
Place the PersonsName control in the Group Header.

 

[Cindy]

You are correct - I was interchanging form & report.
However, that did not work. My data is in 2 tables. A
person comes in and has several issues (needs counseling,
employment assistance, etc.). Each issue has several
resolutions (offered counseling, referred to other agency,
etc.). One table has person's info (Name, address,
unchanging stuff), the other table has the needs and
resolutions with a field common to both tables as the
join. Each need with appropriate resolution is one
record. So in one visit, there could be several records to
print on the report. Any other ideas?

Thanks.

-----Original Message-----

I have a form that needs to be printed and it takes up
the whole page. I would like to keep the report from
advancing to a new page with every record until it gets
to a new person (Put Mr. Smith's 3 records on this form,
then when Mr. Jones info comes up, start a new form and
put all his info on that form, etc.)

Thanks

I'll assume you are interchanging the words form and report and it is
a report you are printing, not a form.

Open the report in Design View.
Click on View + Sorting and Grouping
Enter the [PersonsName] field in the upper left panel.
In the lower panel enter Yes for Group Header.

Set the Group Header's ForceNewPage property to Before Section.
Place the PersonsName control in the Group Header.




--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.