Report Page Break

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/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.
 
Upvote 0
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
 
Upvote 0
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:
 
Upvote 0

Forum statistics

Threads
1,214,798
Messages
6,121,636
Members
449,043
Latest member
farhansadik

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top