468,253 Members | 1,288 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,253 developers. It's quick & easy.

setting subreport background colour to transparent?

I have a report that changes background colour when a running total
field hits a certain value...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [tbCostToMinistry_g] >= 2400001 Then
Me.Section(0).BackColor = 16053492
Else
Me.Section(0).BackColor = 16777215
End If
End Sub

I'm looking for a way to get a subreports background colour to change
along with the main report. There appears to be no 'transparent' option
on the sub report... and all the code I've tried doesn't seem to work
(I'm not very good with VB).

Can anyone help?
Thanks.

Jan 4 '07 #1
2 4855
Mi***********@gov.bc.ca wrote:
>I have a report that changes background colour when a running total
field hits a certain value...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [tbCostToMinistry_g] >= 2400001 Then
Me.Section(0).BackColor = 16053492
Else
Me.Section(0).BackColor = 16777215
End If
End Sub

I'm looking for a way to get a subreports background colour to change
along with the main report. There appears to be no 'transparent' option
on the sub report... and all the code I've tried doesn't seem to work
(I'm not very good with VB).

It needs to be done in the subreport:

If Me.Parent.tbCostToMinistry_g >= 2400001 Then
Me.Section(0).BackColor = 16053492
Else
Me.Section(0).BackColor = 16777215
End If

--
Marsh
Jan 6 '07 #2
Thanks. That worked.

On Jan 6, 7:48 am, Marshall Barton <marshbar...@wowway.comwrote:
Mike.Wolow...@gov.bc.ca wrote:
I have a report that changes background colour when a running total
field hits a certain value...
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [tbCostToMinistry_g] >= 2400001 Then
Me.Section(0).BackColor = 16053492
Else
Me.Section(0).BackColor = 16777215
End If
End Sub
I'm looking for a way to get a subreports background colour to change
along with the main report. There appears to be no 'transparent' option
on the sub report... and all the code I've tried doesn't seem to work
(I'm not very good with VB).It needs to be done in the subreport:

If Me.Parent.tbCostToMinistry_g >= 2400001 Then
Me.Section(0).BackColor = 16053492
Else
Me.Section(0).BackColor = 16777215
End If

--
Marsh
Jan 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Thomas Wieser | last post: by
9 posts views Thread by Rhino | last post: by
2 posts views Thread by Haines Brown | last post: by
8 posts views Thread by Brian Ward | last post: by
2 posts views Thread by kronecker | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.