4
Answers

Change label forecolour if value less than label 1

mike Delvotti

mike Delvotti

10y
766
1
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)