how to change 1 line's color when printing lables??

[SAG]

How do I change the color of line 2 when printing labels
below:

=Trim([CUSTOMER] & " " & [DEALER] & " Batch : "
=Trim([MATERIAL] & " / " & [Style] & " / " & [Holder])
=IIf(IsNull([notes])," ",Trim("Notes: " & [NOTES]))
=Trim("Job # " & [NUM] & " Cab # " & [CABNUM])

Perhaps I could make 2 copies of line 2 and print the
colored version if a condition exists. How can I do that
then if it is the only feasible option?

Steve

 

[Fredg]

Steve,
You haven't said under what condition you wish to change the color.
You haven't said which Access version.

If Access 97 or older:

In the Detail Format event:
If [ControlName] = "Whatever" then
[ControlName].ForeColor = vbRed
Else
[ControlName].ForeColor = vbBlack
End If

If Access 2000 or newer, use the control's Conditional Formatting property.