Conditional formatting on MS Access 2013 report

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.
LVL 1
mlcktmguyAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Make sure the Back Style property is set to Normal.

 Expression is fine, assuming "Note" is the correct field.

Jim.
0
 
mlcktmguyAuthor Commented:
Thank you Jim.  backstyle was set to transparent.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.