Highlight blank field within a report?

Question

I am trying to highlight only a field on reports that are blank.&nbsp; I do not want to highlight the entire row, I just want to be able to highlight specific fields (ie Medical Provider, Our Cost, and Related Office to name a few).&nbsp;&nbsp;
I have tried using formulas with these:
IF(ISNull)
IF(not IsNull)
Nz
I am sure I am just missing something easy, any help would be great
------------------------------Kelly Lyons------------------------------

christopherwhea · Answer

Hi Kelly,

In order to highlight an individual field you'll have to create a Rich Text Formula that will look at your field of interest.&nbsp; This can be a Report Formula or an actual Field in your table.

Here's a very basic example:
var text emptyStyle = "&lt;span style='background-color:yellow;'&gt;";
If([Medical Provider] = "", $emptyStyle, "&lt;span&gt;")
&amp;[Medical Provider]
&amp;"&lt;/span&gt;"

This is assuming [Medical Provider] is a text field.&nbsp; If numeric (like a Related or Cost field) you can use the isNull() or Nz() functions------------------------------Chris Wheatley------------------------------

kellylyons1 · Answer

Thanks Chris, I will give it a try!------------------------------Kelly Lyons------------------------------

Forum Discussion

Highlight blank field within a report?