I know how to change the color of currency based on Positive,Negative,Zero, and Null but how do you change the color of text based on some other criteria. Changing the .ForeColor parameter changes all of the records in the field for that control and that is not what I want.
For example, I want...