Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Don't Print Zero Data

Status
Not open for further replies.

TDM112

Technical User
Jun 25, 2002
5
US
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?
 
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.
 
Sorry left out the Else statment from the above reply

FIELD_NAME.Visible = True

Otherwise all the records become invisible.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top