Conditional Expression, Change To Red is >30

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

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
 
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
 
Back
Top