Link to home
Create AccountLog in
Avatar of Derek Brown
Derek BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Page breaks or not depending what mood access is in.

Can anyone point me to some useful document that may through some light on howon earth you work with page breaks.

I insert a page break to end one page so next page of report starts on a fresh page and it keeps giving an additional blank page.
SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Derek Brown

ASKER

No but I'll give it a go
Thanks Ray
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Also, ..depending on your layout, there may be different ways to avoid blank pages.

So you need to provide a very specific example of your report (in a sample database), ...and exactly where you want the page to break (in all situations)
it is not clear if when you say:
I insert a page break to end one page
...if you are inserting a page break object, ...or setting the force new page property

Keep together (Section and Grouping)
Force New page
Repeat Section
...etc
...all can have some effect on the final output

JeffCoachman
Can anyone point me to some useful document that may through some light on how on earth you work with page breaks.

No, but I can shed some light on how I work with them.
Page breaks have a .Visible property.
If they are not visible, they don't happen.
If they are in a report section that is not visible, they don't happen.
I usually look at Sorting & Grouping and create an appropriate section to drop the Page Break into as the sole control.

Then with VBA, I set up conditions to make the Page Break visible or not as appropriate.
You REALLY need to have a good grasp of the order of events for Reports, though
https://support.office.com/en-us/article/Order-of-events-for-database-objects-e76fbbfe-6180-4a52-8787-ce86553682f9#bm5
And you need to watch out for the pitfalls of what occurs when a report Previews, versus what happens when it Prints, because -- contrary to intuition -- they are not identical.

Those things you usually discover by trial and error
Personally, it's best to stay away from hard page breaks.  Same is true in Word; you use them until you figure out how Word works and then you never bother with them again.

Jim.
I don't have them willy-nilly, but they're indispensable for things like a grouping on true/false field where if all the values are true,  or they are all false, no break is needed. But if there are some true and some false AND another condition not readily determined by the underlying query is also true that a break is then needed -- well, then a page break control is pretty much a must.

I've got 5 or 6 in 160 reports.