Link to home
Start Free TrialLog in
Avatar of runner100
runner100

asked on

money field

Hi,

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.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of brewdog
brewdog

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of toys032498
toys032498

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

$0.00;-$0.00;""

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...