Still Need Help with formating Report 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?

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.
 
Iryder,

you need to use .value ....

Me.TextName.Value

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

Users who are viewing this thread

Back
Top Bottom