Don't Print Zero Data

[TDM112]

I have a report Ive been working on. If the value for a particular field is submitted via a form comes out to be 0.00, I dont want it to display on my report printout. Ive tried all kinds of statements, but I cant get it to work. Any suggestions?

 

[flaniganmj]

If I understand your probblem correctly, the code below should work. In the Detail OnFormat Event use

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

If FIELD_NAME.Value = 0 Then

FIELD_NAME.Visible = False

Else

End If

End Sub

Hope thats what you needed.

 

[flaniganmj]

Sorry left out the Else statment from the above reply

FIELD_NAME.Visible = True

Otherwise all the records become invisible.