Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 30th, 2004, 02:36 PM
SGL SGL is offline
Registered User
 
Join Date: Aug 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Conditional Hide Report Page Header

I am looking for a way to conditionally hide the page header of a report. The report groups by people on field [person ID]. The [person id] footer has property Force New Page = after section. The page header should not appear on the first page of each person's group section of the report. If the person has more than one page to their section of the report, then the page header should appear on all subsequent pages of their report.

Seems I recall the ability to have [Page] reset itself to 1 for each section that forces a new page. If so, then would the following work?

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
    If Me.Page = 1 Then
        Me.PrintSection = False
    Else
        Me.PrintSection = False
    End If
End Sub

Thank you.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting on report in Access bronen Access VBA 3 August 1st, 2008 07:33 AM
Conditional Format of Sub-report lryckman Access VBA 2 July 24th, 2007 09:23 AM
Conditional display/hide of images bertvanpet Crystal Reports 0 May 25th, 2007 02:37 AM
hide/show header with javascript crmpicco Javascript How-To 2 April 10th, 2006 03:45 AM
Hide 0 value in a Report Asif2005 Classic ASP Basics 1 March 7th, 2005 06:21 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.