mike Delvotti

mike Delvotti

  • NA
  • 262
  • 0

Change label forecolour if value less than label 1

Apr 9 2014 3:10 PM
I'm trying to change the fore colour of my labels if they are less than the value of another label by -2

Example, on my form I have 11 labels then I have another label lets say called "total" that will contain a value for instance 100.

I'm trying to achieve a formula that will check the values in labels 1 - 11 and if the value is less than the value in 'Total' by 2 change the label colour to red.

So if label named 'total' was 100 and labels 2 & 4 had a value of 98 or less the fore colour of labels 2 & 4 would change red.

Is this achievable? I would like to fire this in the form load event really. 

Answers (4)