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].

 

[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.

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

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.

 

[fredg]

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.

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

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.

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

 

[fredg]

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.

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


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.

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

I goofed. I meant to write:

Code the Group Header Print Event:
intGroupStart = 1

 

[EManning]

Thanks. That did it.

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.

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


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.

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

I goofed. I meant to write:

Code the Group Header Print Event:
intGroupStart = 1