Conditional formatting for report text box

What would be the correct syntax in the Conditoinal formattnig dialog for the below condition?  that is, if the Date in the control is less than Today plus seven AND another control (TaskCompletionDate) on the report is null, then I want this control to be red, bold.

Date()+7 And IsNull([TaskCompletionDate])
Sandra SmithRetiredAsked:
Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:

expression is [controlName]= Date() + 7 and  [TaskCompletionDate] Is null
Use Expression IS, and place the following in the text box:

[TaskCompletionDate] <= Date()+7 And IsNull([TaskCompletionDate])  = TRUE
Sandra SmithRetiredAuthor Commented:
Thanks Cap, now I need to figure out how to formt the label in red.  But that is aother question.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.