Steven,

>Is there a way to check the condition of a field and the turn a text box on the report to a particular color?

put something like this in the refresh event of the textbox

DO CASE
   CASE SomeExpression
        THIS.Forecolor=nSomecolor

   CASE SomeExpression
        THIS.Forecolor=nSomecolor

   ....
ENDCASE

To check the status of a field, you might want to look at the GETFLDSTATE()function etc.

Walter,