L Ladi Feb 9, 2005 #1 Hi everybody, Is there any chance to alternate colors in report with tabular data? Ladi
R Rick B Feb 9, 2005 #2 What do you mean? What are you specifically trying to accomplish? What determines which data is colored which color? What do you mean by tabular data?
What do you mean? What are you specifically trying to accomplish? What determines which data is colored which color? What do you mean by tabular data?
F fredg Feb 9, 2005 #3 Hi everybody, Is there any chance to alternate colors in report with tabular data? Ladi Click to expand... Do you mean alternate detail row colors? 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.
Hi everybody, Is there any chance to alternate colors in report with tabular data? Ladi Click to expand... Do you mean alternate detail row colors? 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.
