Link to home
Start Free TrialLog in
Avatar of vbnetcoder
vbnetcoder

asked on

access report page break

I want a page break in my report for each new instance of a field [first name].  how do I do this?
ASKER CERTIFIED SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vbnetcoder
vbnetcoder

ASKER

how do I do that?
To be more exact i need a sample...i reckon that you have grouped the records via [First Name]
so it should have a header and a footer (if not add) ...just go to the space in the Footer and put a Page Break
Here's a picture..  Add a group by name section.  The example picture groups by year.
User generated image
You accepted an answer that says to do this in the footer.  As you can see by my example, the setting is in my header and I am using Before Section.  I suppose the footer will work if you use After Section although you may end up with an extra blank page at the end of the report.