Can anybody help?
I'm trying to apply conditional formatting to a report control (Difference) which holds values ranging from 100 to -100. I want to format the control as so:
=> 0 = green
< 0 and > -10 = yellow
=< -10 = red
I have used Conditional formatting in Access 2000 to do this, but it will only respond to the first negative condition and turns all negative numbers orange.
To overcome this, I have turned to VBA and have written some code in the OnFormat event of the controls section
Dim Difference As Single
If Me!Difference >= 0 Then
ElseIf Me!Difference < 0 And Me!Difference >= -10 Then
EsleIf Me!Difference < -10 Then
This brings up the sames results, i.e. all negative numbers are displayed as orange. How do I overcome this and make access recognise more than one conditional format on negative values?