Highlighting Rows

  • Thread starter Thread starter J
  • Start date Start date
J

J

I was wondering how I can highlight an entire row in a report grey when
a value in a column is less than 0. Any help would be appreciated.
 
try the following in the Print event procedure of the report's Detail
section, as

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

If Me!ControlName < 0 Then
' set to gray from standard palete
Me.Detail.BackColor = 12632256
Else
'set to white
Me.Detail.BackColor = 16777215
End If

End Sub

hth
 
Back
Top