Which control has focus?

[Mark A. Sam]

Hello,

Is there a way to detect which control on a form has the focus?

Thank you and God Bless,

Mark A. Sam

 

[Steve C]

Hello,

Is there a way to detect which control on a form has the focus?

Thank you and God Bless,

Mark A. Sam

Hi Mark,

You can use Screen.ActiveControl

HTH
SteveC

 

[Douglas J. Steele]

Screen.ActiveControl returns a reference to the actual control:
Screen.ActiveControl.Name will return its name.

 

[fredg]

Hello,

Is there a way to detect which control on a form has the focus?

Thank you and God Bless,

Mark A. Sam

MsgBox Screen.ActiveControl.Name

 

[Marshall Barton]

Is there a way to detect which control on a form has the focus?

If you know which form contains the control, then use the
form object's ActiveControl property. E.g. if the code is
in the same form as the control, then use Me.ActiveControl.

If the code has no idea which form contains the control,
then you will have to use Screen.ActiveControl

 

[Mark A. Sam]

Thanks for the help. I used Me.ActiveControl.Name.

I never used the ActiveControl property outside of the current control's
event procedures. I never thought of it.

God Bless,

Mark