Fill specified Field

  • Thread starter Thread starter lryder
  • Start date Start date
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?

Thanks for the help-but I was wondering if you could help me with it a little more? 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.

[This message has been edited by lryder (edited 11-17-2000).]
 
On Format
If Me.TextName >15 Then
Me.Textname.ForeColor = VbRed
Else Me.TextName.ForeColor = VbBlack
End If
HTH
 

Users who are viewing this thread

Back
Top Bottom