Positive symbol before numbers (1 Viewer)

[jadeIT]

Is it possible to format a number field so that a positive (+) symbol appears before a positive number, just like a negative (-) symbol appears before a negative number.

 

[jadeIT]

I figured it out:

=IIf(([recieved]-[ordered])>0,"+" & [recieved]-[ordered],[recieved]-[ordered])

Easy

 

[Rich]

Is this for display on a form or report, if so the just set the format for the control to
+#,##0.00[Black];-#,##0.00[Red]"Dr"

 

[jadeIT]

hey thats good... also it looks like you haveanswered another question i have been wanting to know for ages (changing colour for record depending on value).

i will test it out..

thanks a lot!

 

[jadeIT]

i have another question..

is it possible to set a field so that if the number is less than 0 it is stored as 0 (ie so negative numbers are stored as zero)?