<> instead of - for numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Steve,

Try setting the format property for the control to something along these
lines...
#;<#>;0
 
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
 
Back
Top