Setting text baox property

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
 
A

Allen Browne

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