Show textbow if value is Not Null

[Guest]

Hi!
I have added a textbox with a hyperlink to my form. I want the textbox to
show only for the records that have a hyperlink.

How do I make a text box show only if the value is not null?

Thanks!
/Johanna

 

[Dirk Goldgar]

In

Hi!
I have added a textbox with a hyperlink to my form. I want the
textbox to show only for the records that have a hyperlink.

How do I make a text box show only if the value is not null?

Is your form in single form view or continuous forms view? In single
form view, you can use code in the form's Current event to show or hide
the text box; e.g.,

Private Sub Form_Current()

With Me!txtHyperlink
.Visible = Not IsNull(.Value)
End With

End Sub

If your form is in continuous forms view, though, that approach won't
work.