Formatting a "field" in report based on date

[Montez659]

Is it possible when generating a report based off of a query to either highlight or change the color of the text of a certain field based on it's value? For instance, the report being generated from the query pulls in the estDueDate and I would like to make this the color red if it is greater than today.

Thanks in advance for all the help past, present, and future!

 

[revans]

In the Detail or Group Header of wherever you have your date field put this in the On Print event (or possible the On Format event)

If Nz(me.estDueDate,#11/11/1111#) > Date() then
  me.estDueDate.ForeColor = vbRed
Else
 me.estDueDate.ForeColor = vbBlack
End If

hth,

Rich

 

[Montez659]

Rich,

Not quite getting that to work. My texbox is in the Detail area of the report, and I tried it in both the On Print and On Format function, as code and as an expression and none of these have worked. Your code looks good, so what am I doing wrong?

EDIT: Got it to work in the On Paint method. Thanks for the help!