Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

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.
0
runner100
Asked:
runner100
1 Solution
 
brewdogCommented:
Put some code on the format event of your report that says:

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

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

hope one of those helps.

brewdog
0
 
toys032498Commented:
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.
0
 
DedushkaCommented:
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...
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now