Not Printing $0 fields

  • Thread starter Thread starter Eric Chajmovic
  • Start date Start date
E

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
 
Eric said:
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?
Click to expand...

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)
 
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
 
Back
Top