Conditionally Format Line Base on Page Number

scotthutchings

Registered User.
Local time
Yesterday, 20:24
Joined
Mar 26, 2010
Messages
96
I need to hide some lines on the first page of a report but display them on subsequent pages. I was able to do it with the controls using conditional formatting but it does not appear that I can do that with lines. Any ideas?

Thanks!
Scott
 
You can test the Report.Page property and if it's 1, don't print the line, so handle the format event of the section in which the line appears. Code might look like...
Code:
Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
[COLOR="Green"]  'set the line visible if this is not the first page[/COLOR]
  Me.Line1.Visible = (Me.Page <> 1)
End Sub
Does that solve it?
Mark
 

Users who are viewing this thread

Back
Top Bottom