Setting text baox property

  • Thread starter Thread starter Leslie Isaacs
  • Start date Start date
L

Leslie Isaacs

Hello All

I have:

Private Sub Form_Current()
If [Text17].Value = 1 Then
[Text17].Visible = False
Else
[Text17].Visible = True
End If
End Sub

which works fine - except that it applies the visible property to [text17]
in every record according to the value of [text17] in the current record,
whereas what I wanted was to have [text17] visible only for those record
where it's value is not 1.
I should add that the default view for the form is continuous form.

Hope someone can help
Many thanks
Les
 
You cannot selectively show/hide a text box on different rows of a
continuous form.

In Access 2000 and later, you can simulate the effect with conditional
formatting, e.g. by setting the ForeColor and BackColor to the same value
depending on the contents.
 
Back
Top