Each Change in PageHeader

B

Ben Adams

1. How can I determine a change in the field on the Pageheader
2. Then how can I change a box backcolor for each different pageheader?

Using this for a catalog, want colored indexes on the side of the report

Any Ideas?
 
S

Steve Schapel

Ben,

I suppose you could do the laborious hard-code approach, for example...

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)
Select Case Me.YourControl
Case 1
Me.YourBox.BackColor = 65535
Case 2
Me.YourBox.BackColor = 16711680
Case 3
Me.YourBox.BackColor = 255
Case 4
Me.YourBox.BackColor = 6723891
End Select
End Sub
 
Top