For years I have created Access databases, reports, queries (intermediate level)...since the 90's. I have always had problems with inserting random page breaks after report sections so the data isn't on one page and the totals on the next page. I know how to insert a hard page break, but since reports (as repeatedly edited) may not always break at the same place, I need to be able to set up a page break after a completed section of data (so totals aren't on next page, for instance). Can you help?
To break page on a specific section, you can open the report in design view, select the section on property pane, then change "Force New Page" setting to "before section" or "after section".
Your email address will not be published. Required fields are marked