Negative numbers with parenthesis

[Spinbud]

How do I make negative numbers in a report have parenthesis around them? With
currency it is very easy but I cannot figure out how to do it with
non-currency numbers (there is no format that is obvious)

Many thanks.

 

[fredg]

How do I make negative numbers in a report have parenthesis around them? With
currency it is very easy but I cannot figure out how to do it with
non-currency numbers (there is no format that is obvious)

Many thanks.

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

Look up Format Property + Number and Currency datatypes for
information on why this works.

 

[Spinbud]

Thanks, this worked. Quick question, how do I get the comma when more than a
thousand, for example, (3,456) instead of (3456).

Many thanks.

 

[fredg]

Thanks, this worked. Quick question, how do I get the comma when more than a
thousand, for example, (3,456) instead of (3456).

Many thanks.

You're not limited to just #.
You could use
#,###;(#,###);0
or ....
The below will display the comma separated thousands and also always
show 2 decimals.

#,##0.00;(#,##0.00);0.00;

displays as
1,234.00 or (1234.00)
1,234.10 or (1,234.10)
0.25 or (0.25)
0.05 or (0.05)
0.00
etc......

 

[Spinbud]

Thank you very, very much. You have answered my question very well. I
appreciate your time.