S sam Sep 4, 2003 #1 different color for odd rows and even rows Is this possible with Access If so how. TIA sam
A Arvin Meyer Sep 4, 2003 #2 sam said: different color for odd rows and even rows Is this possible with Access Click to expand... For reports: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Section(0).BackColor = 16777215 Then 'If white Me.Section(0).BackColor = &HDFDFDF Else Me.Section(0).BackColor = 16777215 'else white End If End Sub For forms, see Stephen Lebans website: http://www.lebans.com/conditionalformatting.htm -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
sam said: different color for odd rows and even rows Is this possible with Access Click to expand... For reports: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Section(0).BackColor = 16777215 Then 'If white Me.Section(0).BackColor = &HDFDFDF Else Me.Section(0).BackColor = 16777215 'else white End If End Sub For forms, see Stephen Lebans website: http://www.lebans.com/conditionalformatting.htm -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
