Not Printing $0 fields

[Eric Chajmovic]

Hello,

In my report, I am trying to supress the appearance of
two labels and a textbox on a report if the textbox
contains $0 (zero dollars). How can I do this?

Thanks,

Eric

 

[Marshall Barton]

In my report, I am trying to supress the appearance of
two labels and a textbox on a report if the textbox
contains $0 (zero dollars). How can I do this?

Use code in the Format event fo the section containing the
text box and labels:

Me.label1.Visible = (Me.thetextbox <> 0)
Me.label2.Visible = (Me.thetextbox <> 0)
Me.thetextbox.Visible = (Me.thetextbox <> 0)

 

[Duane Hookom]

You could use code in the On Format event of the section containing the
controls.

Me.lblLabelA.Visible = Me.txtA <> 0
Me.txtA.Visible = Me.txtA <> 0