Formatting Number In Accounting Format - BCP

B

BCP

I have what I hope is a VERY simple question. I need to replicate the Excel
"Accounting" format, i.e. negative numbers are in parenteses ($2,000.00) and
red. The currency part I can get through the Format function but showing
negatives in the parenthesis has me stumped.

Any suggestions would be greatly appreciated.
 
D

Duane Hookom

You can set these attributes in the Format property of a text box on a form
or report. Check Help for the specifics.
 
D

Duane Hookom

Did you look at Help under the format property and currency? Try set the
format property to something like:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
 
Top