|New! Download Access Report Banding Database Example|
In this example we use 'Dim gbl_shade As Boolean'. Create the event procedure code as show below. This code will interrogate the gbl_shade variable and when it is True the report line background color gets changed (in this case the highlight color will be yellow-gold). After the if statement the code switches the gbl_shade variable to the opposite boolean value.
Newly figured out simple method without all the complexity of the above alternating line color code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As
If Me.Detail.BackColor = 16777215 Then
Me.Detail.BackColor = 12582910
Me.Detail.BackColor = 16777215
Now, isn't the above code much simpler?
A Blue Claw Database Design Article:
Microsoft Access On The Internet
Microsoft Access 2013 2010 All Windows Versions
Copyright 2000-2017 Blue Claw Database Design