Report Conditioonal format

  • Thread starter Thread starter Junior
  • Start date Start date
J

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
 
Junior said:
In a report [RptOne] -
i want [txtRcvd] to change color if its [txtRcvd] <>"X" and [txtRMK]="RSM"
how would i code the conditional statement
Click to expand...


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
 
Back
Top