Visible When Printing

[Adam McReynolds]

I am trying to make a label visible on a form during print if a field has "like a string". We use a form so that it prints 3 forms to one page (They are tags for units for repair). I can get the label to be visible in the form view but when I print, the label is visible on every record where it is only visible on the current record in form view. My goal is to have the label only show on those records where the condition is met. Here is my code that works in form view only:
(It is to designate easier a warranty tag from a new repair tag)

If Me.Problem_Description Like "Warr*" Then
Me.lbl_w.Visible = True
Else
Me.lbl_w.Visible = False
End If

I have attached an image of a tag sheet . As you can see if I got my desired result only the first tag would have a W.

Thanks for any input.

 

[pbaldy]

Most of us would recommend printing reports, not forms. You have a lot more control over the output with a report. In a report, that code would work in the detail format event or you could use Conditional Formatting. In a form, CF might be the only option (and I don't think CF works on labels, so it would need to be a textbox).