Hide Page Header

[orna]

Hi,
I have page header in a report (Access97),
the data in certain running is over two pages and on the third page there are summings, how can I hide the
page header in the third page.

TIA

 

[PaulBricker]

If you always want the page header for page 3 not visible then you could use this code in the Format Event for the Page Header.

If Me.Page = 3 Then
Me.PageHeaderSection.Visible = False
Else
Me.PageHeaderSection.Visible = True
End If

If you want the last page always not visible then try this

If Me.Page = Me.Pages Then
Me.PageHeaderSection.Visible = False
Else
Me.PageHeaderSection.Visible = True
End If

Paul

 

[orna]

Thanks Paul
I want to check whether there is more data and determine
if I want the page header

 

[teebird]

Hi

I have used your code but I get an error messgage...

Data method not found

any suggestions

 

[PaulBricker]

teebird, post what you have and where you have it and I'll look at it.

orna, are you saying you need something else. I didn't quite understand what you meant in your last post. Sorry.

Paul

 

[orna]

I fix my problem by adding a more suitable grouping.
Thanks Paul