Still Need Help with formating Report Field

[lryder]

I am trying to color a text box in my report. I want to have the field red if the the calculated field is greater then 15 minutes. I have looked at the RBG function and the FillProperty can't get it either to work for me- any ideas?

I've tried:

On Format
If Me.TextName >15 Then
Me.Textname.ForeColor = VbRed
Else Me.TextName.ForeColor = VbBlack
End If

When I put the If statement in of "If Me.TextName >15 Then" I am getting an error message of "You entered an expression that has no value". If I just use the "Me.Textname.ForeColor = VbRed" part of it- things are fine. If you can help me out that would be great.

 

[Former]

Iryder,

you need to use .value ....

Me.TextName.Value

Hope this helps

 

[Richie]

Where are you putting the code? It needs to go in the on format of the detail section.