Disaable all or a type of fields when user form opens

[ootkhopdi]

Hi

i want to display records in user form "frm_r"
it having many records in many text boxs..
i want to disable all text boxs when open form or form view as read only untill Btn_updt not clicked..

please tell me how can i do it..

thanks in advnce

 

[Norie]

You can disable/enable all the textboxes on a userform with code like this.

Dim ctl As MSForms.Control

    For Each ctl In Me.Controls
        If TypeName(ctl) = "TextBox" Then
            ' toggle Enabled property
            ctl.Enabled = Not ctl.Enabled
        End If
    Next ctl

 

[ootkhopdi]

Thanks Norie ,, but code is not working
now i m doing as all textbox are set in a frame.. which enable property is false mean it is disable.

so all textboxs are disabled now..after click on btn_update all properties change to enable. for enable text boxs..

thanks once again

 

[Norie]

How is it not working?

How did you try it?