can you use shading in reports?

G

Guest

Put something simlar to the code below in your On Format
Event Procedure. To do this right click on the Detail
bar and select 'Build Event'. To test for 'Fail' you
need to have a control in your detail section
called 'Fail'. I have mine calculate True or False. If
you are looking for a specific value then you would chage
it to 'Fail=123' or whatever you are testing for. Then
you have to set the rest of the controls in that section
of the report to have a transparent background.

If Fail Then
Detail.BackColor = 15066597
Else
Detail.BackColor = vbWhite
End If
-----Original Message-----
Does anybody know how to effectively use shading in
reports. I want to basically put a very light color in
the background behind a specific section of my report to
make it "stand out" against the rest of my report which
has a white background. I've tried creating a rectangle,
but there are no options to put it behind the objects on
the form. Any suggestions are much appreciated
 
Top