how display negative numbers as (x,xxx)?

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

Guest

Thanks for any help.
I have a form that views at a query, and there are some negative numbers
that are shown as -x,xxx in the form. Can I display as (x,xxx)?
Thanks
 
Thanks for any help.
I have a form that views at a query, and there are some negative numbers
that are shown as -x,xxx in the form. Can I display as (x,xxx)?
Thanks
Click to expand...

No decimal value?
What about Zero?

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

In Access help, for more information look up

Format Property + Number and currency datatype
 
Use the Abs Function, it Returns a value of the same type that is passed to
it specifying the absolute value of a number

Abs(Mynumber)
 
Set format property --

+0.0;–0.0;0.0
Display a plus (+) or minus (–) sign with positive or negative numbers;
display 0.0 if the value is zero.

+0.0;(0.0);0.0
Displays negative numbers as (3.04) instead of -3.05.
 
Back
Top