Access 2007 which control has focus

Last edited: Aug 11, Daveyk01 Registered User. Local time Today, Joined Jul 3, Messages Why doesn't this work? For Each Ctl In Forms! Controls If Ctl. ActiveControl Then Ctl. Try If ctl. Name Then. Last edited: Dec 30, Local time Today, Joined May 3, Messages 1, Daveyk01 said:. ByteMyzer said:.

In what function, sub or event are you calling this code? A simpler way would be to incorporate an error-trap, like the following: Code: Copy to clipboard. A form and controls on a form aren't visible until the form's Load event has finished. Therefore, if you use the SetFocus method in a form's Load event to move the focus to that form, you must use the Repaint method before the SetFocus method. You can't move the focus to a control if its Enabled property is set to False.

You must set a control's Enabled property to True 1 before you can move the focus to that control. You can, however, move the focus to a control if its Locked property is set to True. If a form contains controls for which the Enabled property is set to True , you can't move the focus to the form itself. You can only move the focus to controls on the form. In this case, if you try to use SetFocus to move the focus to a form, the focus is set to the control on the form that last received the focus.

Text property from one of the boxes. However, I am still getting a compile error "Method or data member not found. By the way, this references a text box txbTestMO that I hope to change what it displays on the click event of a command button btnRunSales. The program stops on the first line of code, that is, "Private Sub. Text property of the line assigning the string variable to the text box is highlighted. Yellow arrow. Value, 3, 4 txbTestMO. Text is highlighted in blue. Value in the variable assignment to a.

Text in the text box reference. So, I changed everything to. Value and it made no difference. After your last post, I decided to see what would happen if I renamed the TextBox. Guess I had changed the lablel while thinking I was clicking the TextBox. Stupid mistake. Oh well, some days you are the windshield; some days you are the bug. Thanks for your help. Glad I could help. Email Required, but never shown.

The Overflow Blog. Podcast Explaining the semiconductor shortage, and how it might end. Does ES6 make JavaScript frameworks obsolete? Featured on Meta. Now live: A fully responsive profile. Linked 0. Related 0. Hot Network Questions.