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

  • Thread starter Thread starter SAG
  • Start date Start date
S

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