David Emerson
newsgrps at dalyn.co.nz
Sat Aug 31 16:09:37 CDT 2013
This worked - I created a new group with an expression "=0" and put the page header controls into the group header with the Repeat Section property set to yes. This put the group header on top of every page where there were assets and not on the pages after which were defined by sections after the new group footer. (Rocky - I had already tried your suggestion of using the print event of the header to find a test to see if I was about to print a checklist and make the header section visible=false, but I couldn't get it to work from the examples I found on the net and the final solution was much easier.) Thanks again to a great team of experts. Regards David Emerson Dalyn Software Ltd Wellington, New Zealand -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Saturday, 31 August 2013 10:40 p.m. To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Hiding Report Page Headers Thanks Steve, Found it eventually (it was April 2012). Will see if I can use it. David -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stephen Bond Sent: Saturday, 31 August 2013 1:51 p.m. To: Access Developers discussion and problem solving Subject: Re: [AccessD] Hiding Report Page Headers Try the archives. Charlotte posted a solution to something similar on April 5. The subject was "Can Grow" Property in Report Page Header but her answer covered more than that. Stephen Bond -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Saturday, 31 August 2013 10:01 a.m. To: Stephen Subject: [AccessD] Hiding Report Page Headers I have a report that is in two parts - The first is a list of assets, the second is a list of service checklists (these are subreports that are placed onto the main report). There could be several sites in the report (ie Site 1 asset list followed by checklists, Site 2 asset list followed by checklists etc). Each site begins on a new page. The list of assets could run over several pages and has text to appear at the top of every page (page header). The list of service checklists could also run over several pages but should not have the page header showing. Since the page header takes about a quarter of the page I would like the area used for the checklists instead of appearing blank. Any pointers for this - Google searching has not come up with anything that works in my situation. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com