change detail section background color

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

change detail section background color

Author

Topic

kaus
Posting Yak Master

179 Posts

Posted - 2003-08-04 : 13:52:06

Hi - I want to change the detail sections's background color whenever the grouping header changes -- does anyone know how to do this ?? I've been looking at the format method for the detail section and possibly getting the value of the header at this time but dont know how to get it

Thanks

Pete

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-08-04 : 14:52:03

Private Sub DetailSection_Format(Cancel As Integer, FormatCount As Integer)

If Me.YourKeyControlInGroupingHeader = 2 Then
Me.DetailSection.BackColor = vbRed
Else
Me.DetailSection.BackColor = vbGreen
End If

End Sub

- Vit

kaus
Posting Yak Master

179 Posts

Posted - 2003-08-04 : 16:01:22

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources