What is the name of your Rich Text field? Try adding it to the report. :)
Hi Mark,
Ok I've tried that but get another error as the [Survey Completed] field is a date format field, ="" doesn't then work.
Qrew LegendOk, so both fields are date fields. Then IsNull should work fine.
i would think this should work.
If( IsNull([Survey Completed]) and [Survey Required By]<=Today(), "<div style=\"color:white;background-color:red;\">" & ToText([Survey Required By]) & "<div>" ,
ToText([Survey Required By])
Thanks Mark,
So ok, I've tried that, but sadly still no joy...
If(
IsNull([Survey Completed]) and [Survey Required By]<=Today(),
"<div style=\"color:white;background-color:red;\">" & ToText([Survey Required By]) & "<div>",
ToText([Survey Required By])
)should make this red, with white text:
But as you can see, its not.
However, running their formula checker on that record, to me, reads as if it should be working? Seems to give me a true result to both checks, and result from the expression is with the html div tag with colour. So I don't know why its not applying?
Any further suggestions before I give up?
Do I need to apply it to a specific field id or something? Although to me, specifying the totext() with field name is supposed to work, right?