Conditional Formatting for Negative numeric values

D

DaveAlfa

Hi!

i have a text field 'Profit'on a form set as Standard & would like to show
it in red if the Profit is < 0

Thus, i have set the Conditional Formatting for this field 'Field Value is
Less Than 0' to red, else it should be shown in blue. But, this is not
working! all values are shown in blue, even if profit is -10!!

On further testing i found out that 10 or -10 is the same value for
Conditional Formatting.

am i doing something wrong?!?

thanks

Dave
 
F

fredg

Hi!

i have a text field 'Profit'on a form set as Standard & would like to show
it in red if the Profit is < 0

Thus, i have set the Conditional Formatting for this field 'Field Value is
Less Than 0' to red, else it should be shown in blue. But, this is not
working! all values are shown in blue, even if profit is -10!!

On further testing i found out that 10 or -10 is the same value for
Conditional Formatting.

am i doing something wrong?!?

thanks

Dave
Click to expand...

You probably are doing something wrong, but there is a much simpler
method if the Datatype of the field [Profit] is Number or Currency.
Set the control's Format property to:

#,###.## [Blue];-#,###.## [Red];0 [Blue];

Look up Format Property + Number and Currency datatypes
in Access help.
 
Top