Microsoft Access Conditional Formating Not working on Access 2016

Question

I want to use conditional formatting to highlight the entire row of a report that I created. I'm using a data field named "Permit Status" to and the Field data is the Word "Approved". in Design mode I clicked on the field Named "Permit Status" and clicked conditional format. I used the Field Value is = to "Approved". Below are the formulas I used.

Value="Approved"  for the Permit Status field, this worked and in print preview only the fields with "Approved" in them were highlighted green.

**[Permit Status]="Approved"**I used this formula on the other fields in the row  and in Print preview none of the fields in the row were green.

NOTE: I check the "Back Style" in Properties and it was set to "Normal"

Please help

Answer 1

I answered my own Question, Access is very interesting, I reformatted the Permit status Data type to a simple Drop down list  as apposed to a lookup. That was the problem.