J Junior Nov 8, 2004 #1 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?
F fredg Nov 9, 2004 #2 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
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 Nov 9, 2004 #3 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...
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...
