Question Conditional Formatting (1 Viewer)

[alktrigger]

Access 2007

I am trying to set up a conditional formatting on the cells in a report, but I can't seem to get it right, I searched but didn't find anything applicable.

I'm having issues with turning a certain text value yellow. The fields have 4 specific outputs. Empty (null), any possitive integer, zero, or "N/A".. I can get the first 3 to format correctly, but the N/A field does not want to format correctly.

Condition:
[Expression Is] : "N/A"

But this does not seem to work, any suggestions?

 

[Galaxiom]

Field Value is | Equal To | "N/A"

 

[alktrigger]

thank you. I feel like an idiot... I deserve to.

 

[Galaxiom]

There is so much in database design that sometimes the wood is not visible for the trees. We have all spent many an hour in the wrong tree.