Adding text to box based on criteria used

[Ekhart]

I have a report that shows all records that need action done to them. This may be 'Needs Appt. Date' or 'Appt has passed' or 'Follow up on Letter Sent'. Each criteria line in my query refers to one of these reasons. I can use conditional formatting easy enough to highlight something but rather than using 20 different colors, each indicating a specific issue, I wanted to add a text box to the beginning of the report that would simply say 'Needs Appt. Date' on a line and 'Follow up on Letter' on, for instance, the next line if that line used THOSE criteria to land it on the report.



I included a snip of my query form rather than trying to explain what my criteria are.

[ranman256]

put the fields on the report, make them invisible.
in the report turn them on if needed in the ON PRINT event
txtNeedsAppt.visible = NeedsAppt.value
txt'FollowLtr.visible = Followup.value

[Ekhart]

But how to I make them invisible based on a line of criteria? Where would I put code for this, just in the invisible field?

[ranman256]

when the report runs, the ON PRINT detail event,
it will either hide it /or visible based on your field value.
txtFollowLtr.visible = Followup.value