Format number in Report

  • Thread starter Thread starter Mike C
  • Start date Start date
M

Mike C

I would like to have all negative numbers show as 0. How
can I set the properties in a report to do this? Thanks
in advance.
 
Mike C said:
I would like to have all negative numbers show as 0. How
can I set the properties in a report to do this? Thanks
in advance.
Click to expand...

=IIf([FieldName] < 0, 0, [FieldName])
 
That worked, thank you very much.

-----Original Message-----
Mike C said:
I would like to have all negative numbers show as 0. How
can I set the properties in a report to do this? Thanks
in advance.
Click to expand...

=IIf([FieldName] < 0, 0, [FieldName])


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
 
I would like to have all negative numbers show as 0. How
can I set the properties in a report to do this? Thanks
in advance.
Click to expand...

You can use the Control's Format property to do this.
Set the property to:
#;0;\0

See Access Help files regarding
format Property + Number and Currency datatypes

Or, if this field is part of a concatenated control:
="The amount due is $ " & Format([ControlName],"#;\0")
 
Back
Top