C
Chris Large
Hi
Add the following to the reports Detail section ON Format
event:-
If isnull(Me.[YourTerminationDateField]) Then
Me.Section(acDetail).BackColor = RGB(255, 0, 0)
Else
Me.Section(acDetail).BackColor = RGB(255, 255, 255)
End If
hth
Chris
Add the following to the reports Detail section ON Format
event:-
If isnull(Me.[YourTerminationDateField]) Then
Me.Section(acDetail).BackColor = RGB(255, 0, 0)
Else
Me.Section(acDetail).BackColor = RGB(255, 255, 255)
End If
hth
Chris