Format grouping

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have a report thats using grouping with headers and
footers for a field called Categories. In the
CategoriesHeading Header I have some labels but would like
to hide them for some Categories but not others. Is this
possible, if so... How?

Thanks in Advance
 
You can do the following:

Click on properties for your header. On "On Format",
select event procedure. Then click the symbol with ...
This will take you to class module where you can enter
code something like below.

If (category = "somevalue") Then
Me.label1.Visible = False
Me.label2.Visible = False
End If

This will hide your labels. Make sure you refer to your
labels by name.
 
Back
Top