L
lryder
Guest
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.
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.