Show textbow if value is Not Null

J

JohannaÖhman

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
 
D

Dirk Goldgar

In
JohannaÖhman said:
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?
Click to expand...

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.
 
Top