Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-18-2019, 04:39 PM   #16
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 862
Thanks: 10
Thanked 181 Times in 171 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: On condition, add a blank page to report record

OK, watching ball game so that's it for just a bit. I think i have it.

Micron is offline   Reply With Quote
Old 05-19-2019, 06:47 PM   #17
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 862
Thanks: 10
Thanked 181 Times in 171 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
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".
Attached Files
File Type: accdb Census example4.accdb (568.0 KB, 7 views)

__________________
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.
Micron is offline   Reply With Quote
Reply

Tags
conditional formatting , length , reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Blank extra page when sub report is blank Sharkfin Reports 5 01-06-2012 06:32 AM
Need a blank page after each report. PuddinPie Reports 2 07-06-2011 05:41 AM
How to insert blank page after final page on report pedrok Reports 1 09-05-2004 03:42 AM
[SOLVED] Blank page after final page on report pedrok Reports 0 07-23-2004 05:58 AM
Blank report page SHK Reports 5 05-19-2003 08:15 AM




All times are GMT -8. The time now is 07:00 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World