Changing Colors

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Good Day.

Anyone have a quick trick to change the backColor of a
text field for every other line in a report.

I want one line to be white, the next line of the report
to be grey.

Thanks,
 
Steve said:
Anyone have a quick trick to change the backColor of a
text field for every other line in a report.

I want one line to be white, the next line of the report
to be grey.
Click to expand...


Add code like this to the text box section's Format event
procedure

If Me.textbox.BackColor <> vbWhite Then
Me.textbox.BackColor = vbWhite
Else
Me.textbox.BackColor RGB(192,192,192)
End If
 
Back
Top