"Grey Out" text boxes on forms

[Bisleycat2002]

Can anyone tell me how I go about "greying out" text boxes on a form dependent on the answer to user input on a preceding input on the record i.e. if they answer yes in one box then a subsequent question appears to be "greyed out" indicating it does not require a response.

Thanks

 

[Norie]

There are various ways.

On of which is to use the AfterUpdate of the preceding text box.

eg

Private Sub Text1_AfterUpdate(Cancel As Integer)
    If UCase(Text1) = "YES" Then
        Text2.Enabled = False
    End If
End Sub

 

[Bisleycat2002]

Thanks for the quick reply - is there a way of doing this after using an option group?

 

[Norie]

Yes

Are the options in a frame?

Then use the frame's after update event.

eg

Private Sub Frame0_AfterUpdate()
    If Frame0.Value = 2 Then
        Text1.Enabled = False
    Else
        Text1.Enabled = True
    End If
End Sub

 

[Bisleycat2002]

Thanks again Norie - hey it works as well!!