Re: On condition, add a blank page to report record
Best I think I can do is what's attached. In some? cases there will be an extra blank page at the end. Possibly not if there isn't a couple of stray records on a page, otherwise, with the data provided I get one. If there's a way to detect that the previous page is blank I don't know it. Can't be as simple as counting records in a section, because the blank page is achieved by putting your secondary page break in the section footer (which you didn't create but I added). Thus a prior section does in fact have records but the prior page does not always. Hope this is good enough for now.
EDIT - Forgot to mention that you really should turn on "require variable declaration" in the vb editor. You have Option Compare setting but not Option Explicit. A mis-spelled name can have you spinning your wheels for quite some time while trying to figure out the issue. As someone once wiser than me said "if you don't require variable declaration, you deserve what you get".
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Last edited by Micron; 05-19-2019 at 06:54 PM.