<> instead of - for numbers

S

Steve

Anyone have any hints on how to show a negative number as <100> rather than
-100 in an Access datasheet form, or in general.

Thanks
 
S

Steve Schapel

Steve,

Try setting the format property for the control to something along these
lines...
#;<#>;0
 
F

fredg

Anyone have any hints on how to show a negative number as <100> rather than
-100 in an Access datasheet form, or in general.

Thanks
Click to expand...

With comma separated thousands, and 2 decimal places?

Set the control's Format property to
#,##0.00;<#,##0.00>;0.00

In Access help look up
Format + Number and Currency datatype
 
Top