Supress Report Footer on Certain Values in Field

[TZyk2003]

Good morning all! It's good to be back on this site!

Here's my question.

I have a report footer with only ONE field in it.

I need to set the 'Visible' property of the Report Footer to 'No' if any 1 of a certain 5 values appears in the field in the footer.

What is the VB code to reference this footer??

Many thanks!

-Tim

 

[dhookom]

=IIf(Instr("value1~Value2~Value3~...",txtFieldA)>0,"",txtFieldA)

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[TZyk2003]

Hmm...maybe you didn't understand my question.

I'm using VB code for on "On Open" option for the report. The footer name is [Defect Impacted Center]. There's a field called "Impacted Center" in the footer body.

How do I reference the "Visible" option for the FOOTER (NOT the field) in VB. I'm guessing it's something like Me.[Defect Impacted Center].Visible = False or something like that...

But that's not right...thanks!!

-Tim

 

[dhookom]

Private Sub Defect_Impacted_Center_Format(Cancel As Integer, FormatCount As Integer)
If Me.Impacted_Center = 4 OR _
Me.Impacted_Center = 5 OR _
Me.Impacted_Center = 6 Then
Me.Section("Defect Impacted Center").Visible = False
Else
Me.Section("Defect Impacted Center").Visible = True

End If
End Sub


Duane
MS Access MVP
Find out how to get great answers faq219-2884.