Page Header problem

[Raymond]

Hi all,
I have a report having a page header and details(report header/footer
alongside..)... i have the page header having some Title,Product ID
Description etc..( literally the titles....) and detail section has the
details for these titles.

Now sometimes it happens that the details grow in size and the footers go on
to the next page. Alongside, the page header also comes along the next page.
What I want is that if the details skip to the next page, THEN AND ONLY THEN
the page header should be visible on the other page else not.

I have tried codes like :-

If (Me.Report.Page = 1) Then
Me.PageHeaderSection.Visible = True
Else
Me.PageHeaderSection.Visible = False

or the [page]..

i even tried the width of the detail section to exceed some limit.. But
nothing seems to work...

Please help me !!!!!!! Your help will be, as always, greatly acknowledged...

 

[Allen Browne]

Could you use a group header instead of page header?

1. In the Sorting And Grouping box, add a group header. If what you describe
applies to the entire report, you can enter an expressinon like this as the
field to group on:
=1
Set its Group Header to Yes.
Access adds the group header to your report,

2. Right click the new group header, and choose Properties.
Set its Repeat Section property to Yes.
Move the labels you have in your page header into this group header.

The group header will then appear at the top of each page (because of the
Repeat Section setting), but only where a group header is appropriate (above
details.)

 

[Raymond]

Thnx a ton Allen... it worked just fine!!!!

Could you use a group header instead of page header?

1. In the Sorting And Grouping box, add a group header. If what you describe
applies to the entire report, you can enter an expressinon like this as the
field to group on:
=1
Set its Group Header to Yes.
Access adds the group header to your report,

2. Right click the new group header, and choose Properties.
Set its Repeat Section property to Yes.
Move the labels you have in your page header into this group header.

The group header will then appear at the top of each page (because of the
Repeat Section setting), but only where a group header is appropriate (above
details.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi all,
I have a report having a page header and details(report header/footer
alongside..)... i have the page header having some Title,Product ID
Description etc..( literally the titles....) and detail section has the
details for these titles.

Now sometimes it happens that the details grow in size and the footers go
on
to the next page. Alongside, the page header also comes along the next
page.
What I want is that if the details skip to the next page, THEN AND ONLY
THEN
the page header should be visible on the other page else not.

I have tried codes like :-

If (Me.Report.Page = 1) Then
Me.PageHeaderSection.Visible = True
Else
Me.PageHeaderSection.Visible = False

or the [page]..

i even tried the width of the detail section to exceed some limit.. But
nothing seems to work...

Please help me !!!!!!! Your help will be, as always, greatly
acknowledged...