Avatar of xenium
xenium
 asked on

Detect if tab has focus

Hi,

how can i detect if a tab (or any other object) has the focus?

I can set the focus like this : Forms![Main]![&Fields].SetFocus
but instead i want to detect if it has the focus.

Thanks



Microsoft Access

Avatar of undefined
Last Comment
xenium

8/22/2022 - Mon
slamhound

Have you considered storing a valiable on the click event of the tabs?
Imoutwest

To find which control has focus use: Forms!FormName.ActiveControl.Name

You can use then in a If:Then statement to check your tab.

Dim ActiveCTL as Control
ActiveCTL = Forms!FormName.ActiveControl.Name

If YourControl = ActiveCTL then
     ' Do something if True
Else
     ' Do something if False
End If

I'll have to check this out tomorrow morning as I typing on the fly (dangerous for me), but think I'm in the BallPark...

Imoutwest
ASKER CERTIFIED SOLUTION
Mike Eghtebas

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
xenium

ASKER
Thanks, yes that's what i needed!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23