How do I show a textbox with a yes/no function.

[Rutie]

Hello,
I have a continuous form where I've got a Yes/No function for each
record. What I want to do is, when the Yes/No function is clicked (this
means it will be yes or 1) I want to show (or make visible) a textbox
where I can put in some data.
Can someone help me with this problem.

 

[BruceM]

Yes is -1. You could use something like this in the check box After Update
event and the form's Current event:

If Me.CheckBoxName = -1 Then
Me.TextBoxName.Visible = True
Else
Me.TextBoxName.Visible = False
End If

You could also make the code a public sub or function and call it from an
event.

 

[Rutie]

Hi,
This thing works, but in a continuous form all the records change. The
meaning of this all is that the textbox in a certain record becomes
visible or not.
Thx

 

[BruceM]

That's a few times today I have looked too quickly at a question. You're
right, my suggestion would not work with a continuous form. You may be able
to use conditional formatting to get the desired results. This link:
http://www.lebans.com/conditionalformatting.htm
may provide some additional insight.