Hiding text in Group header

[EManning]

Using A2K. How do I hide text in a group header? I have some text in the
group header that I want to print only on the first page of the new group.
I want it invisible for subsequent pages for the group.

Thanks.

[Duane Hookom]

You could try code in the On Format event of the section:

Me.txtYourControl.Visible = Page = Pages

This may require that you have a control in your page header or footer that
is bound to [Page].

--
Duane Hookom
MS Access MVP

"EManning" <emanning_...@kumc.edu> wrote in message
news:OY1zCVjf...@TK2MSFTNGP12.phx.gbl...

[EManning]

Thanks for your suggestion. If only one group, then your suggestion works
fine if I change "Page = Pages" to "Page <> Pages", otherwise the text I
want visible on the first page isn't but is visible on subsequent pages. So
it's backwards from what I want.

If multiple groups, then the text remains visible on all pages except for
the very last page.

I had a text box bound to [Pages] and added a bound text box to [Page] per
your suggestion.

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:uajuJtjf...@TK2MSFTNGP10.phx.gbl...

[fredg]

See if this method works in your situation.
Dim a variable up in the declaration section of that report's code
sheet:
Option Explicit
Dim intGroupStart as Integer.

Code the Group Header Format event:
ControlName.Visible = intGroupStart = 0

Code the Group Header Print Event:
intGroupStart = 0

Add (if you don't already have one) a Group Footer.
Code the Group Footer Print Event:
intGroupStart = 0
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[fredg]

I goofed. I meant to write:

Code the Group Header Print Event:

intGroupStart = 1

[EManning]

Thanks. That did it.

"fredg" <fgut...@example.invalid> wrote in message
news:1hozpk4vp3zz8$.6tusiolja157.dlg@40tude.net...