Suppress Report Header

[Bill]

Is there a way to suppress the creation
of the header page in a report when
certain conditions are present..........
E.g., like openargs contains a value
that signals to the OnOpen that the
header page is not wanted?

Thanks,
Bill Stanton

 

[fredg]

Is there a way to suppress the creation
of the header page in a report when
certain conditions are present..........
E.g., like openargs contains a value
that signals to the OnOpen that the
header page is not wanted?

Thanks,
Bill Stanton

Code the Report Header Format event:
If Not IsNull(Me.OpenArgs) Then
Cancel = Me.OpenArgs = "Something"
End If

 

[Bill]

Code the Report Header Format event:
If Not IsNull(Me.OpenArgs) Then
Cancel = Me.OpenArgs = "Something"
End If

Simple enough Fred, thanks.

I didn't know that simply canceling the
header formatting would result in the
header page being entirely suppressed.

You understand that I don't want a
blank sheet to come out of the printer?

Bill

 

[Bill]

That canceled the page header and footer also.

Code the Report Header Format event:
If Not IsNull(Me.OpenArgs) Then
Cancel = Me.OpenArgs = "Something"
End If

That canceled the page header and footer also.
I just want to kill off the report header, i.e., the
first page that otherwise contains the report
header.

 

[Bill]

But only on the first page of the report. I.e.,
with the report header page suppressed, the
page that would ordinarily be the second page
of the report has had its page header and page
footer suppressed, including no page number.
The subsequent pages have their headings and
footings formatted correctly except that the
page numbers are now 1 page out of step.