Group Header Visible Toggles

[Guest]

I am using Access 2002.

I have a report with a GroupHeader0 with subtotals in it. I would like to
make this header's Format / Visible property toogle between yes and no, based
on the value in a field SECTION_CODE. If SECTION_CODE = "01", then Visible =
Yes, if SECTION_CODE <> "01" then Visible = No.

I have been messing with this for four hours and no luck...

 

[Marshall Barton]

I am using Access 2002.

I have a report with a GroupHeader0 with subtotals in it. I would like to
make this header's Format / Visible property toogle between yes and no, based
on the value in a field SECTION_CODE. If SECTION_CODE = "01", then Visible =
Yes, if SECTION_CODE <> "01" then Visible = No.

The group header can only refer to value in the group's
first record. If the grouping is on the section code field,
then you can simply use either:
Cancel = (Me.SECTION_CODE = "01")
or
Me.GroupHeader0.Visible = (Me.SECTION_CODE = "01")

in the group header section's Format event procedure.

 

[Guest]

Worked like a charm. The grouping was NOT on Section_Code, it was grouped on
a different field. Section_Code was also not it in the group header...but
this code still worked. (as an event procedure).

Thanks.