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