Background Color

[Meccer]

Hello, I'm creating a report and I want outstanding records to stand out among the rest, each record is listed one beneath the other and I want an outstanding record's color to be red.



I've done this on a different report with only the record details not a list, therefore I used this code which works create:

If Me.Issue = True Then
Me.PageHeaderSection.BackColor = vbRed
End If

The syntax should be correct, I just don't know what field to use, (Issue is a check box)

[alansidman]

Have you considered using the built in Conditional Format function within Access?

Look here for tutorial

http://video.google.com/videoplay?do...2297909344198#

Alan

[Meccer]

Hello Alan,

Thanks for your response, I've looked into conditioning formatting, but it seems no matter what I do the color does not change.

I tried
Expression Is; [Issue]=1 the background must be red

[alansidman]

Change the conditional format to

[issue]=-1

Alan

[Meccer]

Thank you Alan,

Works Perfect!