page breaks

N

Newbie

Hi
I have a report with 3 header sections
Cell
Setter
Machine

I want the report to print with a page break every time there is a change in
Setter. For each change of Cell I would like the first setter to appear on
the same page as the new Cell

eg
Page 1
Cell A
Setter X
page 2
Setter Y
page 3
Setter Z
page 4
Cell B
Setter S
page 5
Setter T etc etc

How can I do this without getting a blank page at the beginning

Thanks
A
 
M

Marshall Barton

Newbie said:
Hi
I have a report with 3 header sections
Cell
Setter
Machine

I want the report to print with a page break every time there is a change in
Setter. For each change of Cell I would like the first setter to appear on
the same page as the new Cell

eg
Page 1
Cell A
Setter X
page 2
Setter Y
page 3
Setter Z
page 4
Cell B
Setter S
page 5
Setter T etc etc

How can I do this without getting a blank page at the beginning

Try playing around with each section's Force New Page
property. I think you may want to set the Setter group
footer section's to After Section. If you don't have a
footer section for Setter, create one and make it very
small.
 
L

Larry Linson

Take a look at the Force New Page property on the Group Header.

Larry Linson
Microsoft Access MVP
 

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