Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do you hide "TextBox" labels on a form if record is null.
Perfect... John, you have been a big help. Thanks again. Mark- CHMPB
- Post #8
- Forum: Microsoft: Access Forms
-
How do you hide "TextBox" labels on a form if record is null.
Hey John, I figured out what I was doing wrong. The textbox name is SQL Batch (w/space) not SQLBatch. I added an underscore to replace the blank and presto, success. Now, I have three others fields on the same form that I want to do this to. In the following example, is this all I need...- CHMPB
- Post #6
- Forum: Microsoft: Access Forms
-
How do you hide "TextBox" labels on a form if record is null.
OK, This is what I have in my Forms "Current Event" [Event Procedure] Private Sub Form_Current() If Nz(SqlBatch, "") = "" Then Label22.Visible = False Else Label22.Visible = True End If End Sub With this the labels gone completely. What am I doing...- CHMPB
- Post #5
- Forum: Microsoft: Access Forms
-
How do you hide "TextBox" labels on a form if record is null.
Ok, one thing I am not understanding... The comments in Your script: Nz(PrpCity,"")="" lblPrpCity Is this where I add my field names and labels? My script: Nz(label22,"")="" lblLabel22 Do I need to add the "lbl" to the beginning of...- CHMPB
- Post #3
- Forum: Microsoft: Access Forms
