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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Negative number alignment 1
Assisgn color to -ve number 2
Is there a bracket (financial) format? 8
Using abs in reports 1
Negative numbers with parenthesis 4
Report made of a query cross table 5
Filtering subreports on main report 0

Back
Top