Conditional Expression, Change To Red is >30

[Gulf Coast Electric]

The field name on form is named Days Past Due as is the Control Source name.
It counts how many days past due the Invoice is.
If it is over 30, I want it to change to Red. Here is the code I tried,
didnt work.





Expression is [Days Past Due]>30

 

[Michel Walsh]

Hi,

Is it possible your [Days Past Due] is a string instead of a number?
Try:


Int( [Days Past Due]) > 30


Is it possible that another condition is applied?


Hoping it may help,
Vanderghast, Access MVP