Text Fields on a report

[petercummins]

Hi people,

I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?

Something like:

Private Sub Report_Open(Cancel As Integer)
If txtFireType = "N/A" Then
txtFireType.Visable = False
End If
End Sub

This doesn't seem to work by the way!

Really appreciate all of your help.

 

[allan57]

try the following

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If txtFireType = "N/A" Then
txtFireType.Visible = False
End If

End Sub

 

[petercummins]

Cheers thats great