Conditional Formatting - Turning on a label field

[Kenny A.]

I have a report that prints out clients that have their contracts expiring
within the next 90 days (no problem). I would like to make a label field
become visible that says Contract Expired when the number of days is now a
negative number (90 days has run out and now into the expired days). I'm not
ure how to set up the conditional formatting to make visible another field
based on the value of another.

Thanks in advance for help

Kenny A.

 

[fredg]

I have a report that prints out clients that have their contracts expiring
within the next 90 days (no problem). I would like to make a label field
become visible that says Contract Expired when the number of days is now a
negative number (90 days has run out and now into the expired days). I'm not
ure how to set up the conditional formatting to make visible another field
based on the value of another.

Thanks in advance for help

Kenny A.

What was your calculation?

Code the Detail Format event:
Me![LabelName].Visible = Me![OtherControlName]<0
Or you might have to repeat the calculation:
Me![LabelName].Visible = (Repeat your calculation)<0