Showing currency field as null

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with 3 currency fields. I would like to show them as blank
instead of $0.00 if there is no data inputted. I have changed the default
value to Null in the table and on each field of the form and it is still
showing as $0.00.

Any suggestions??

Thanks
 
You should be able to set the Format property to display 0 value as empty.
Check Help on "Format Numeric" and try:
Format: $#.00;($#.00);"";""
 
Back
Top