Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Conditional Row Shading on a Continuous Form

Row Shading has come a long way since Access 2003 where you had to use code to get it to happen. Remember this…

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If bluebar Then Detail.BackColor = 16777215 Else Detail.BackColor = 13888992 End If

bluebar = Not (bluebar)

End Sub

Then came Access 2007 and we […]

 2,970 total views