splitting into separate pages

[Nathan]

I have a report in Access 2002 listing students and the
scores they've earned on certain tests. The report has
no page header/footer or report header/footer; all I'm
using is the section header ("Student Header") and
Detail. In the Student Header is the date in which the
tests were taken and the student's name. In the Detail
is a list of all the tests the students took on that
date. The report is currently printing so that all the
scores are on the same page--each student just follows
the previous. How can I get the students' scores to
print on separate pages?

The properties for the Student Header and Detail are the
same:

Force new page - None
New Row or Col - None
Keep Together - Yes
Visible - Yes
Can Grow - No
Can Shrink - No

The Repeat Section property for the Student Header is set
to Yes, so that the student's name and the date are
printed at the top of every page. I have tried changing
all the above properties and nothing seems to work--if I
force a new page after the Detail section, each score is
printed on a separate page.

Thanks for the help

 

[Fons Ponsioen]

I am a little confused.
I think you needa report which is grouped by student, and
in the detail section you list the tests take by that
student.
If you set the properties for the student header to force
new page to before. This should start each students data
on a new sheet. FOr the detail section I would set the
can shrink to yes.
Hope this helps
Fons

 

[fanchant]

You need to make a page footer, then choose Force New Page After in
the properties. You can make the page footer O" in height, so nothing
will actually show for it, but this should solve the problem.

 

[Marshall Barton]

I have a report in Access 2002 listing students and the
scores they've earned on certain tests. The report has
no page header/footer or report header/footer; all I'm
using is the section header ("Student Header") and
Detail. In the Student Header is the date in which the
tests were taken and the student's name. In the Detail
is a list of all the tests the students took on that
date. The report is currently printing so that all the
scores are on the same page--each student just follows
the previous. How can I get the students' scores to
print on separate pages?

The properties for the Student Header and Detail are the
same:

Force new page - None
New Row or Col - None
Keep Together - Yes
Visible - Yes
Can Grow - No
Can Shrink - No

The Repeat Section property for the Student Header is set
to Yes, so that the student's name and the date are
printed at the top of every page. I have tried changing
all the above properties and nothing seems to work--if I
force a new page after the Detail section, each score is
printed on a separate page.

Set the Student Header's ForceNewPage property to Before
Section.