Transparent Background on Subform

[shaqattack1992-newsgroups]

Hello,

I have a report with 2 subreports in the detail section. I have just
changed the report so that if a "Ready" checkbox is checked yes, the
background color of the detail section of the main report changes to
green. I used the following code in the main report format of the
detail section:

If [Ready] = True Then
Section(0).BackColor = vbGreen
Else
Section(0).BackColor = vbWhite
End If

End Sub

This works great, but the background color of my subreports is still
white while the rest of the detail section is green. Is there a way to
make the background color of the subreports transparent so the green
shows through? If not, is there a way to set the background color on
the subreports to the same color as the main report based on the
checkbox condition? Any help would be appreciated.

Thank You,

Chad

[Salad]

sh***********************@yahoo.com wrote:

Hello,

I have a report with 2 subreports in the detail section. I have just
changed the report so that if a "Ready" checkbox is checked yes, the
background color of the detail section of the main report changes to
green. I used the following code in the main report format of the
detail section:

If [Ready] = True Then
Section(0).BackColor = vbGreen
Else
Section(0).BackColor = vbWhite
End If

End Sub

This works great, but the background color of my subreports is still
white while the rest of the detail section is green. Is there a way to
make the background color of the subreports transparent so the green
shows through? If not, is there a way to set the background color on
the subreports to the same color as the main report based on the
checkbox condition? Any help would be appreciated.

Thank You,

Chad

I'm just guessing but you probably have to set the background color of
your subreport to a color also. Change SubReportName to your sub report
name and see if that works.

If [Ready] Then
Section(0).BackColor = vbGreen
me.SubReportName.Report.Section(0).BackColor = vbGreen
Else
Section(0).BackColor = vbWhite
me.SubReportName.Report.Section(0).BackColor = vbWHite
End If

[Pachydermitis]

Go into Design view on both reports
Right click on the background of the parent report and copy the 'Back
Color' property
Right click on the background of the child report and paste into the
'Back Color' property
Or a variaton on what salad was telling you
In the subreport . . .
Private Sub Form_Load()
On error resume next
Me.Detail.BackColor=Me.Parent.Detail.BackColor
End Sub
HTH
Pachydermitis

[shaqattack1992-newsgroups]

That worked perfectly. Thanks for the help.

Chad