Access

Hi Kate

Thank you for your question

I have uploaded a database with one form in it. It has 4 text boxes and a check box. The check box has the following code attached to its "after update" event

Private Sub chk1_AfterUpdate()





    If Me.chk1.Value = True Then

    

        Me.txt1.Visible = False

        Me.txt2.Visible = False

        Me.txt3.Visible = False

        Me.txt4.Visible = False

        

    Else

    

        Me.txt1.Visible = True

        Me.txt2.Visible = True

        Me.txt3.Visible = True

        Me.txt4.Visible = True

        

    End If



End Sub

This code will run everytime the value of the check box is altered. It gives you the general code that you would have to write. The key is to set the visible property of the relevant text box to "true" or "false".

I hope this helps. If you require further clarification please don't hesitate to repost

Regards

Stephen