formatting a negative number

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

How do i format a txtbox containing a number
(double-2 decimals)
to display inside parenthesis ( ) if it is negative?
 
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
 
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...
 
Back
Top