D
dbl
Hi I have added a field called txtInFoPlus which if there is no data the
field is not visible but the fields remain visible.
The following code worked with only the txtInFo field
Private Sub Form_Current()
If IsNull(txtInFo) Then
txtInFo.Visible = False
Else
txtInFo.Visible = True
End If
End Sub
So I adjusted the code as follows with the new field txtInFoPlus but the
field txtInFoPlus field has the #Name error and both field are visible. Any
idea's what I am doing wrong ? If you take the txtInFoPlus field out of the
code you do not get the #Name error.
Private Sub Form_Current()
If IsNull(txtInFo) Then
txtInFo.Visible = False
If IsNull(txtInFoPlus) Then
txtInFoPlus.Visible = False
Else
txtInFo.Visible = True
txtInFoPlus.Visible = True
End If
End If
End Sub
Thanks Bob
field is not visible but the fields remain visible.
The following code worked with only the txtInFo field
Private Sub Form_Current()
If IsNull(txtInFo) Then
txtInFo.Visible = False
Else
txtInFo.Visible = True
End If
End Sub
So I adjusted the code as follows with the new field txtInFoPlus but the
field txtInFoPlus field has the #Name error and both field are visible. Any
idea's what I am doing wrong ? If you take the txtInFoPlus field out of the
code you do not get the #Name error.
Private Sub Form_Current()
If IsNull(txtInFo) Then
txtInFo.Visible = False
If IsNull(txtInFoPlus) Then
txtInFoPlus.Visible = False
Else
txtInFo.Visible = True
txtInFoPlus.Visible = True
End If
End If
End Sub
Thanks Bob