money field


I got some money field in my form and if I dont write anything in the field I want to be able to print my report but in the field where there is no amount enter I dont want to see the 0.00 $  I want the field to be empty in my report.

Who is Participating?
brewdogConnect With a Mentor Commented:
Put some code on the format event of your report that says:

If IsNull([Money]) Then
    [Money].visible = false
    [Money].visible = true
End If

Or you can change the forecolor of the text box to white, or ...

hope one of those helps.

You could add code in the After Update, or on the Lost Focus, or put in the report on the On Open to read:

If myfield.text = 0.00 then
myfield.text = ""
End If

You could also just change the format to read after update.
Hi, runner100!

In the report design view set (do not select from list, just overtype) for your money field the value of format property instead default Currency format to this (or like this) format


first part is format ($0.00) for positive values,
second (-$0.00) -for negative,
third ("" empty string) - for zero values, so $0.00 do not print.

Good luck, runner100...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.