Hide a section based on contents at run-time

[skk]

Can you specify more than one fields to suppress header the when there are no
data?
below is for one field but I have to use more than one field. If it is yes,
could you also, show me the syntax? Thank you in advance.

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
Cancel = (Nz(Trim([LaborCatagory]), "") = "")
End Sub

 

[Duane Hookom]

If I understand correctly:
Cancel = Nz(Trim([LaborCatagory]), "") = "" OR Nz(Trim([another field]),
"") = ""

You didn't say how you wanted to "use more than one field".

 

[skk]

Thank you for the reply. I wanted to use the "AND" and I'll give it a try.

If I understand correctly:
Cancel = Nz(Trim([LaborCatagory]), "") = "" OR Nz(Trim([another field]),
"") = ""

You didn't say how you wanted to "use more than one field".
--
Duane Hookom
Microsoft Access MVP

Can you specify more than one fields to suppress header the when there are no
data?
below is for one field but I have to use more than one field. If it is yes,
could you also, show me the syntax? Thank you in advance.

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
Cancel = (Nz(Trim([LaborCatagory]), "") = "")
End Sub