A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Eliminate Report Footer Conditionally



 
 
Thread Tools Display Modes
  #1  
Old December 16th, 2004, 04:37 PM
Dan
external usenet poster
 
Posts: n/a
Default Eliminate Report Footer Conditionally

How do I keep the footer from printing as a blank page when I have the footer
section visible property set to No, but conditionally set it to True as in
the following:

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtCountChains 1 Then Me.ReportFooter.Visible = True
End Sub

Whenever txtCountChains = 1, I want to hide the footer, but don't want a
blank page either. Since there are controls in the footer, I can't change the
footer height to 0.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Totals by date on report footer Brent Setting Up & Running Reports 1 October 9th, 2004 03:33 AM
Save Report With CreateReport Coding Issue Jeff Conrad Setting Up & Running Reports 8 July 12th, 2004 08:39 AM
Creating a report from a form Kristin Setting Up & Running Reports 7 June 28th, 2004 09:21 PM
Report footer gorgas Setting Up & Running Reports 1 May 21st, 2004 03:55 AM


All times are GMT +1. The time now is 04:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.