alktrigger
Aimless Extraordinaire
- Local time
- Today, 14:24
- Joined
- Jun 9, 2009
- Messages
- 124
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?
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?