M mcnewsxp Oct 13, 2008 #1 how can i change the fill color for the detail line every other line - from no color to gray? tia, mcnewsxp
how can i change the fill color for the detail line every other line - from no color to gray? tia, mcnewsxp
F fredg Oct 13, 2008 #2 how can i change the fill color for the detail line every other line - from no color to gray? tia, mcnewsxp Click to expand... Make sure the BackStyle of each control is Transparent. Code the Detail Format event: If Me.Section(0).BackColor = vbWhite Then Me.Section(0).BackColor = 12632256 ' gray Else Me.Section(0).BackColor = vbWhite End If ==== If you wish each page to start with a white row, code the Page Header Format event: Me.Detail.BackColor = 12632256 'Reset color to Grey so that the first detail line will become white Change the colors as needed.
how can i change the fill color for the detail line every other line - from no color to gray? tia, mcnewsxp Click to expand... Make sure the BackStyle of each control is Transparent. Code the Detail Format event: If Me.Section(0).BackColor = vbWhite Then Me.Section(0).BackColor = 12632256 ' gray Else Me.Section(0).BackColor = vbWhite End If ==== If you wish each page to start with a white row, code the Page Header Format event: Me.Detail.BackColor = 12632256 'Reset color to Grey so that the first detail line will become white Change the colors as needed.
