What is the name of your Rich Text field? Try adding it to the report. :)
Qrew LegendIn order to check whether a text field is blank you need to check it against empty quotes. It is obscure, but it is documented that The is no function. Does not work on text fields.
In order to check whether a text field is blank you need to check it against empty quotes. It is obscure, but it is documented that The is no function does not work on text fields.
So if [survey completed] as a text, feel like yes no,
then use
if([Survey completed] = ""
another tip is that if you were checking a freeform data entry text field to be blank. I do this.
if (Trim([my field]) = "", ......
Just in case the user has entered some empty spaces in the field
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?