I have a datasheet subform that i want to have the rows shaded if one of the fields is not in this month. I put this code in and what it's doing is shading everything solid black. I don't know what number is associated with which color, but I figured any number would be different, but there is no difference.
If Month(Me.SchedShip) > Month(Date) Then
Me.DatasheetAlternateBackColor = 5
Me.DatasheetBackColor = 5
Me.DatasheetAlternateBackColor = 1
Me.DatasheetBackColor = 1