Label not to show on Report

[Bob]

I want the label on a report (Label87) not to show if the text box
(text107) has not data in it!
Thanks for any help.........................Bob

 

[Bill Mosca, MS Access MVP]

Use the section's format event. This tests text107 for length (number of
characters). If it is null or empty, the label will be invisible.
Label87.Visible = len(text107 * vbNullString)>0

 

[Bob]

Bill it just freezes my db when I go to print preview, does this look right?
Regards Bob
Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As
Integer)
Label87.Visible = len(text107 * vbNullString)>0
End Sub

 

[Van T. Dinh]

Try:

Label87.Visible = Len([text107] & vbNullString)>0

I think that's what Bill meant ... The keys & and * are right next to each
other on the keyboard ...