Conditional Formatting for Negative numeric values

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

Guest

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
 
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.
 
Back
Top