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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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...
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...
If myfield.text = 0.00 then
myfield.text = ""
End If
You could also just change the format to read after update.