Avatar of Derek Brown
Derek Brown
Flag 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.
Microsoft Access

Avatar of undefined
Last Comment
Nick67

8/22/2022 - Mon
SOLUTION
Rey Obrero (Capricorn1)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Derek Brown

ASKER
No but I'll give it a go
Thanks Ray
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jeffrey Coachman

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
Nick67

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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Jim Dettman (EE MVE)

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.
Nick67

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.