[draceplace]

I've got a sub report that displays the 'CC:'s" for a letter if they are entered on a form. When there is no data in the CC textboxes the sub report still displays the "CC:" label on the letter. I want to suppress that. I've tried these.

Private Sub Report_Load()
If Me.Text78 Is Null Then
Me.Label44.Visible = False
End Sub

Where text78 is the first CC entry on the (sub)report (from the CC textbox of the form).

Private Sub Report_NoData(Cancel As Integer)
Cancel = True
End Sub

Anybody know this one?

[OBP]

You want to use the Subreport's "On No Data" event procedure to make the field or subform invisible.