|
Subject:
|
How to determine which text box has focus
|
|
Posted By:
|
JAnthony
|
Post Date:
|
4/17/2006 11:19:03 AM
|
Another question: I have a form with multiple text boxes on it, and I only want to write one program (and not insert the code into the double click event of every text box).
How do I go about determing which text box has the focus?
or any other suggestions would be great.
John
|
|
Reply By:
|
bab02
|
Reply Date:
|
4/17/2006 6:55:30 PM
|
You can set on the form open event
Private Sub Form_Open(Cancel As Integer)
'The text box you want available
TextBoxName.SetFocus
TextBoxName.Locked = False
TextBoxName.Enabled = True
'The text box you dont want available
TxtNm.Locked = True
TxtNm.Enabled = False
End Sub
|
|
Reply By:
|
AvGuy
|
Reply Date:
|
4/19/2006 2:29:28 PM
|
You can use the ActiveControl property to refer to the control that has the focus at run time together with one of its properties or methods. The following example assigns the name of the control with the focus to the strControlName variable:
Dim ctlCurrentControl As Control
Dim strControlName As String
Set ctlCurrentControl = Screen.ActiveControl
strControlName = ctlCurrentControl.Name
If no control has the focus when you use the ActiveControl property, or if all of the active form's controls are hidden or disabled, an error occurs.
AvGuy
|
