Access Conditional formatting

[gheyman]

I have a bunch of fields on a form where I entered conditional formula

"Check values in the current record or use and expression
Format on cells where the:
Field Value is greater than 0


Then the formatting is set to make the fore color red

if the value, which is calculated, results in 0 it stays black, if its greater than 0 it turns red BUT if its a negative number (like -1) it turns red. negative 1 is less than 0 so it should stay black. What am I doing incorrectly?

I tried "0" which not difference on results

 

[alansidman]

Click on the Refresh Button and see if that makes a difference.

 

[welshgasman]

Does the same for me in 2007.

However if you change it to Expression Is and then the formula like [txtColour]>0 it will do as you wish.

HTH

 

[gheyman]

When you state (txtColor] do you mean a color or are you saying to you want like [Red]>0?

if I but [textcolor]>0 and then go below that section and select red from the color pallet nothing happens when the condition is met

 

[welshgasman]

No, [txtColour] is the name of the control you are checking to see if the value is > 0
I just created a form and put one control on it called txtColour.

 

[gheyman]

Thanks.

 

[apr pillai]

Expression Is sgn([TextColor])<=0 - Black

Expression Is sgn([TextColor]) > 0 - Red

 

[jassicaT]

not seeing any different. can you please explain me again.

 

[apr pillai]

not seeing any different. can you please explain me again.

The expression will check the sign of the value in the field.
If the value in the field is negative it will evaluate to -1
if field value is Zero then sgn() function will return 0

if the field value is a positive number then sgn() will return +1

Based on this three returned values (-1, 0 or 1) you can define the color of the field value you want.

 

[welshgasman]

What benefit is there of adding extra code of the sgn function when testing the value will do the same?