showing a date conditionally 1

[RnRExpress]

Howdy folks.

I have been messing around with a report, and have frield If Then's, and IIF as well, without any luck. So, its time to ask all your fine experts.

On a report, I have a Currency field, called "Charge".
I also have a unbound text box set to show a medium date, which represents the date the Charge was applied.

What I am trying to do, is make it so if the Charge is $0.00 (I have the input mask on this field set to 900.00), then have this date field not appear. And if there is a charged amount, then have the date appear.

Thanks again and hope y'all have a tremendous holiday season!!

Richard

 

[Zion7]

RNRExpress, if this control is in the detail section of the report, you case use the Detail_OnFormat event, of the report.

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

If Charge.Value > 0 Then Applied.Visible = True Else Applied.Visible = False

or, just for the record...

Applied.Visible = IIF(Charge.Value > 0, True, False)

End Sub

Hope this helps, good luck

 

[RnRExpress]

Thank you Zion7.. that worked awesome.

Much apreciated!

Richard