Conditionally formatting report sections 1

[ChrisN]

Is it possible to hide/supress a group header based on the value of a field in a higher level group??

Thanks in advance.
Chris

 

[PaulBricker]

Probably. In the Format Event for the lower Group Header you would use something like this.

If Me.HigherGroupHeaderValue = "ABC" Then
Me.LowerGroupHeader.visible = False
Else
Me.LowerGroupHeader.visible = True
End If

Now the success of this will depend on exactly what you are trying to do but it's a starting point for you.

Paul

 

[ChrisN]

Thanks Paul,

That kind of works but hides all group headers.

What I am requiring is as follows;

If TopGroup = 1 then show low group header otherwise if topgroup = 2 then hide low group header but obviously only within that top group.

Hope this gives you a bit more information as to what I am looking for.

Chris

 

[ChrisN]

OK thanks, I cracked it!

I was just trying to call the value in my text control (in the higher group) incorrectly so your code worked fine!

Thanks again,
Chris