How can I show a negative amount in a report with a minus sign?

[andrea5977]

I would like negative amounts to show on my reports with a minus sign instead
of being in parantheses. Is there a way to do this? I am using Access 2003.

 

[fredg]

I would like negative amounts to show on my reports with a minus sign instead
of being in parantheses. Is there a way to do this? I am using Access 2003.

Set the Format property of the control (in the report) to:
#;-#;0