GroupHeader Repeat

[Lamar]

I have report named "PaymentHistory". This report has a section
"PaymentHeader" where Repeat property is set to "Yes". So this group header
repeats on the next page or column.

My problem I have a text box named "txtName" in this group header but I do
not want the txtName to repeat. txtName is what the user inputs. txtName
needs to be in the group header the first time but I want to make invisible
if the group header repeats.

How can I do this? Any help is appreciated.

 

[Marshall Barton]

I have report named "PaymentHistory". This report has a section
"PaymentHeader" where Repeat property is set to "Yes". So this group header
repeats on the next page or column.

My problem I have a text box named "txtName" in this group header but I do
not want the txtName to repeat. txtName is what the user inputs. txtName
needs to be in the group header the first time but I want to make invisible
if the group header repeats.

The trick is to determine the first from subsequent
instances of the header. This can be done by adding a
(hidden?) text box (named txtDtlCnt) to the detail section,
set its control source to =1 and RunningSum to Over Group.

Then, in the header section format event:
Me.txtName/Visible = (Me.txtDtlCnt = 1)

 

[BruceM]

Marsh must have missed the period key and hit the slash next to it instead.
That's supposed to be a dot before Visible.

 

[Marshall Barton]

Lousy keyboard is always ducking away from my hammer handed
typing ;-)

Thanks for spotting the typo/^H.