Conditon Format 2 fields

[Guest]

I have a series of score codes that are in a report in 2 fields, ScoreCode
and MS.

If the student actually took the test his score code is S. If they actually
passed the test then the MS field =1. I want to coditionally format a field
that says if the score code =S and the MS=1 then turn the background grey
otherwise leave it alone.

I can format them separtely, I just can't seem to figure out how to get 1
field to look at the other field before it turns a color.

 

[fredg]

I have a series of score codes that are in a report in 2 fields, ScoreCode
and MS.

If the student actually took the test his score code is S. If they actually
passed the test then the MS field =1. I want to coditionally format a field
that says if the score code =S and the MS=1 then turn the background grey
otherwise leave it alone.

I can format them separtely, I just can't seem to figure out how to get 1
field to look at the other field before it turns a color.

Using Access 2000 or newer you can use conditional formatting.

In Report Design View, select the [ScoreCode] control and the [MS]
control.
Click on Format + Conditional Formatting
Select
Expression Is
from the Condition1 dropdown.
In the next box write:
[ScoreCode] = "S" and [MS] = 1
Select the backcolor you wish.
Save the changes.