Report Section

[Dwight]

How can I programatically determine what section the
report is in, using the On Page event?

Here is an example of what I have tried:
*********************************************

Private Sub Report_Page()

If Me.Report.Page = 0 Then
Else
If Me.Section.Name = "Detail" Then
Me.PageHeaderSection.Visible = True
Me!tbNameLine.Height = 555
Else
End If
End If


End Sub
****************************************************
Thanks in advance!

Dwight

 

[Allen Browne]

The report is not working on any of the sections at the time it is
formatting the Page, so you will not be able to set the heights and
visibility of the sections.

You can discover the page number from the Page variable (though it would not
normally be page zero unless you set it so).