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.
 
You must log in or register to reply here.

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

Similar Threads

Label for totals in group footer 2
Please help! Section Header w Count of Unique 1
Unique counter in section HEADER 2
Creating a Report with Mulitple Headers 2
Report - Sorting and Grouping 1
Grouping 2
page header on second page of invoice. 3
Gouping In Sub Reports Leaving Windowed Headings 2

Back
Top