Make label invisible

[Kirk P.]

I've got this code that runs when I open the Group Changes report. When
txtTermDate is null, it does make the text box invisible. But the label
still remains visible. What's the deal?


Private Sub Report_Open(Cancel As Integer)

If IsNull(Me!txtTermDate) Then
Me.txtTermDate.Visible = False
Me.lblTermDate.Visible = False

End If

End Sub

 

[Rick Brandt]

I've got this code that runs when I open the Group Changes report. When
txtTermDate is null, it does make the text box invisible. But the label
still remains visible. What's the deal?


Private Sub Report_Open(Cancel As Integer)

If IsNull(Me!txtTermDate) Then
Me.txtTermDate.Visible = False
Me.lblTermDate.Visible = False

End If

End Sub

Is the label "attached" to the TextBox? If it is then its visibility should
stay synchronized with the TextBox.

 

[Duane Hookom]

The code should be in the On Format event of the section containing the
controls. You also need to add code to set Visible back to True when
txtTermDate is not null.

Me.txtTermDate.Visible = Not IsNull(Me.txtTermDate)

 

[Kirk P.]

How can I tell if the label is "attached" or not?

 

[Van T. Dinh]

In the Design View of the Report, select the Label by clicking on it. Do
you see a small black square appear on the top-left corner of any other
Control. If you do, the Label is attached to the other Control. If you
select the other Control, you will see a small black square on the top-left
corner of the Label.