Please help!

[Fred's]

Hi Folks,

I already have this fuction below that makes my details section of my
report in colour Grey, if my control
"[QuaniteRecu]" = true


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [QuaniteRecu] = True Then
Me.Section(0).BackColor = 12632256
Else
Me.Section(0).BackColor = vbWhite
End If
End Sub


Now I will like to if there a similar function that can make my text
boxes on my report in colour "grey" if the quantity in into my text
boxes are higher than 0.

Can someone tell me which function I can use to make this happening?
Or if there is another way to do this?
Please let me know!

Thank you to all,

Fred's

 

[Duane Hookom]

I replied to your other recent request suggesting you look into Conditional
Formatting. You didn't reply in that thread. Have you tried this?