GroupHeader Repeat

G

Guest

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

Marshall Barton

Lamar said:
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)
 
B

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

Marshall Barton

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

Thanks for spotting the typo/^H.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top