Changing Color Based On A Database Value

[RV76]

Is there a way I can change the color of a actuate report field based on a database value? For example, I want the font to be in red color if the value is "Y".

 

[ASG0856]

Right Click the relevant text object
Select the methods tab.
Select the Sub(On Row)Method
Select Override

After the 'Insert Code Here line and before the End Sub line;
Dim A Variable as String
Variable = row.getvalue("db field")

If Variable = "Y" Then
Font.color = Red
End If