Suppress Report Header

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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
Click to expand...


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

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
 
That canceled the page header and footer also.


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

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.
 
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.
 
Back
Top