Solved

How do I remove the focus off a control through a macro so that I can hide it?

Posted on 2008-10-05
2
243 Views
Last Modified: 2013-11-28
I have a macro that hides a number of controls after clicking a control called cmdLogout. However, I want cmdLogout to also hide as the macro executes. But this brings up an error because it cannot hide a control that has the focus. How do i remove the focus from the control so that it can be hidden?
0
Comment
Question by:Anneline
2 Comments
 
LVL 33

Accepted Solution

by:
Mike Eghtebas earned 500 total points
ID: 22647093
On your form add a text box (txtDummy). It remains unbound (nothing in its control soutce), width = 0.

In Gotfocus event of txtDummy have:

txtName.visible = false
.
.
.
cmdLogout.visible = false
etc.

And in Click event of cmdLogout have:

Sub cmdLogout_Click()
.
.your existing code
.

Me!txtDummy.SetFocus
End Sub

Mike
0
 

Author Closing Comment

by:Anneline
ID: 31503296
Thanks!
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question