In my Access 2013 application I want to highlight a field 'Note' on a report with a yellow background if it contains any data. If there is nothing in the field I take no action.
Not sure what I'm doing wrong but it's not working.
I opened up conditional formatting on the field and entered this rule:
'Expression Is' and Len(Trim(Nz([Note])))>0 and selected yellow as the background color.
The field is not highlighted on the report regardless of whether it contains data or not.