Report Page Break

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Darth Access

New Member
Joined
Dec 21, 2005
Messages
4
You cannot insert a page break in a section, only before or after... Here's how:

Once you have assigned levels of grouping to the report, and made a header and/or a footer visible for these groups you can click on the properties of said header/footer and under the Format tab you will see the item;

Force New Page

You can elect to select either:
  • None
    Before Section
    After Section
    Before & After Section

Hope this answers your question.
 

pritcham

Board Regular
Joined
Oct 26, 2005
Messages
128
Hi

I've just tried it and you can use the "Page Break" control to insert a break anywhere you need to, whether it's a section or summary/footer etc. The Page Break control is shown in the Toolbox of the report design screen and looks like two split pages with an arrow pointing to the break (on my screen it's between the "Bound Object Frame" button and the "Tab Control" icons.

Cheers
Martin
 

Darth Access

New Member
Joined
Dec 21, 2005
Messages
4
Fair shout,

Martin's right! I never new about that button! I love Access, I've using it for 8 years and I'm still learning! :LOL:
 

Watch MrExcel Video

Forum statistics

Threads
1,118,450
Messages
5,572,181
Members
412,447
Latest member
immy
Top