formatting a negative number

J

Junior

How do i format a txtbox containing a number
(double-2 decimals)
to display inside parenthesis ( ) if it is negative?
 
F

fredg

How do i format a txtbox containing a number
(double-2 decimals)
to display inside parenthesis ( ) if it is negative?
Click to expand...

Set the control's Format Property to:
#;(#);0

Or, if you wish comma delimited thousands and 2 decimals, use
#,##0.00;(#,##0.00);0

See Access Help:
Format Property + Number and Currency datatypes
 
J

Junior

thanks
fredg said:
Set the control's Format Property to:
#;(#);0

Or, if you wish comma delimited thousands and 2 decimals, use
#,##0.00;(#,##0.00);0

See Access Help:
Format Property + Number and Currency datatypes
Click to expand...
 
Top