<div>
Private Sub Form_Load()<br />
&nbsp; &nbsp; 'Sets .Locked=True for all TextBoxes on Form1<br />
&nbsp; &nbsp; Dim ctrlText As TextBox<br />
&nbsp; &nbsp; For Each ctrlText In Me.Controls<br />
&nbsp; &nbsp; &nbsp; &nbsp; ctrlText.Locked = True<br />
&nbsp; &nbsp; Next ctrlText<br />
End Sub<br />

</div>


Private Sub Form_Load()
    'Sets .Locked=True for all TextBoxes on Form1
    Dim ctrlText As TextBox
    For Each ctrlText In Me.Controls
        ctrlText.Locked = True
    Next ctrlText
End Sub


<div>
'use the KeyPress event.<br />
<br />
Private Sub textFields_KeyPress(Index As Integer, KeyAscii As Integer)<br />
If &quot;your condition&quot; = &quot;criteria&quot; Then<br />
&nbsp; &nbsp; textFields(Index).Locked = True<br />
End If<br />
End Sub<br />
<br />
S<br />

</div>


'use the KeyPress event.

Private Sub textFields_KeyPress(Index As Integer, KeyAscii As Integer)
If "your condition" = "criteria" Then
    textFields(Index).Locked = True
End If
End Sub

S


<div>
That did not work... error on: &nbsp; &nbsp; &nbsp; ctrlText &nbsp; &nbsp; ????
</div>


That did not work... error on:       ctrlText     ????

<div>
<div class="content wysiwyg-content">
I have a form that has several text boxes on it. I wish to LOCK all the text boxes until a certain condition s met. &nbsp;Is there a way to LOCK all text fields with having to lock each one by its property screen?<br />
<br />
The boxes are all named: &nbsp; textFields(1) &nbsp; &nbsp;textFields(2) &nbsp; textFields(3), &nbsp; &nbsp; etc....<br />
<br />
Thanks<br />
<br />
Charlie<br />
<br />

</div>
</div>


I have a form that has several text boxes on it. I wish to LOCK all the text boxes until a certain condition s met.  Is there a way to LOCK all text fields with having to lock each one by its property screen?

The boxes are all named:   textFields(1)    textFields(2)   textFields(3),     etc....

Thanks

Charlie



Lock all text boxes on a form

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.