Report Conditioonal format

[Junior]

In a report [RptOne] -
i want [txtRcvd] to change color if its [txtRcvd] <>"X" and [txtRMK]="RSM"
how would i code the conditional statement
thanks

 

[Marshall Barton]

In a report [RptOne] -
i want [txtRcvd] to change color if its [txtRcvd] <>"X" and [txtRMK]="RSM"
how would i code the conditional statement

You can use Conditional Formatting (Format menu) and set its
Expression Is: to just what you have above.

If you prefer to do it with VBA, use code like this in the
Format event procedure of the section containing txtRcvd:

If [txtRcvd] <>"X" and [txtRMK]="RSM" Then
[txtRcvd].ForeColor = vbRed
Else
[txtRcvd].ForeColor = vbWhite
End If