Hello everyone,
I have a report with approximatelly 100 records in Detail section (4 pages).
The requirement is to display 15 bottom controls on the Front page and hide 10 of them on the other pages showing only 5 bottom controls.
As my aprroach, I put all 15 controls on the Page Footer Section.
Then I use the code below:
The issue is that Page Footer Section takes one third of a page.
Therefore, one third of a page is blank on all other pages except the Front page.
Does anybody know how to display some of bottom controls on Front page and hide them on other pages without having the blank space?
Thank you.
sudakov.
I have a report with approximatelly 100 records in Detail section (4 pages).
The requirement is to display 15 bottom controls on the Front page and hide 10 of them on the other pages showing only 5 bottom controls.
As my aprroach, I put all 15 controls on the Page Footer Section.
Then I use the code below:
Code:
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page = 1 Then
Me.Control1.Visible = True
Me.Control2.Visible = True
.
.
.
Me.Control10.Visible = True
Else
Me.Control1.Visible = False
Me.Control2.Visible = False
.
.
.
Me.Control10.Visible = False
End If
End Sub
The issue is that Page Footer Section takes one third of a page.
Therefore, one third of a page is blank on all other pages except the Front page.
Does anybody know how to display some of bottom controls on Front page and hide them on other pages without having the blank space?
Thank you.
sudakov.