Suppress page header if page starts off with new section

  • Thread starter Thread starter Lee Stafford via AccessMonster.com
  • Start date Start date
L

Lee Stafford via AccessMonster.com

I have a report that has the page header and the section header as the
same. Sometimes the section will start new in the middle of the page and
it needs headings above the columns to make it look good and readable.
However, sometimes a new section will start on a new page and then it has
two headers that are the same, one on top of the other. Is there a way to
suppress the page header, if a new section is started on the top of the new
page?

TIA,

Lee S.
 
Lee said:
I have a report that has the page header and the section header as the
same. Sometimes the section will start new in the middle of the page and
it needs headings above the columns to make it look good and readable.
However, sometimes a new section will start on a new page and then it has
two headers that are the same, one on top of the other. Is there a way to
suppress the page header, if a new section is started on the top of the new
page?
Click to expand...


Your use of the word "section" is somewhat confusing.
Reports have sections (Header, Page, group headers, etc.),
but it sounds like you mean something else. I think you
probably mean group header.

If so, then use a little code in the group footer section's
Format event to make the Page Header section invisible.

Me.Section(3).Visible = False

Then make it visible again in the group header section's
Format event:

Me.Section(3).Visible = True

You may want to try a different approach by deleting the
Page header altogether and just set the group header
section's RepeatSection property to Yes.
 
Thanks for replying. You were correct in thinking I was talking about the
group header. I am a little confuse about where exactly to put that code.

Right now, the page header is suppressed on the first page because of the
Report Header. So, the report goes like this....

1st pg

Report Header
System Header
Supervisor Header
System Footer
(New system) System Header
Supervisor Header
pg break

2nd pg

Page Header
System Header (same as Page Header) System Header repeats for any group
that is split up.
System Footer

The report will not always be generated this way, of course, but in this
case it does look odd to have the page header and the system header on top
of each other.

I put the code in the places I thought you were talking about, and it
didn't change anything. Sorry, could you be more specific?

Thanks,

Lee
 
Back
Top