Color around command button that gets focus when form opens

Posted on 2014-11-12
Last Modified: 2014-11-14
On a form I have a command button.  I have that command button getting the focus when the form opens with:

Private Sub Form_Open(Cancel As Integer)


End Sub

Open in new window

But then the command button gets a blue color around it because it has the focus,  Is there a way to change this so there is no color around it?
Question by:SteveL13
  • 4
  • 3
LVL 33

Expert Comment

by:Mike Eghtebas
ID: 40438867
You possibility could replace this button with a label and make it look like a button.

You can use its click event and press event feature could be added to it all minus that blue line.

Such a label will not get focus period.
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 40440165
Just curious: Why would you NOT want the user to know where the focus is on the form? That is basic Windows user conventions, and in general it's not a good idea to go against those sort of ingrained paradigms. Users are accustomed to looking for an object that has the focus ...

That said: You might be able to include a veeeeery small button on the form, and give that the focus when the form starts. Users would very likely not see it (and you could perhaps hide it behind something else) - but that still begs the question of why you don't want the user to see it ...

Author Comment

ID: 40440184
The form is really just a launchpad with command buttons that execute other forms or reports.  By design I have the exit command button being the focus but then the blue "halo" around it.

I will try the small button under another object.
LVL 33

Accepted Solution

Mike Eghtebas earned 250 total points
ID: 40440201
Now that your concern is known. Have a textbox with width = 0 and intedex tab of zero. The same effect as a small button but unlike a button, it will now show a helo. Samll button, no matter how small will still get helo.

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

LVL 33

Expert Comment

by:Mike Eghtebas
ID: 40440288
Thank you but this should be shared with Scott for asking the essential question I failed to ask. If you could use Request Attention to reopen and the question to share the points.



Author Comment

ID: 40440369
I have requested attention.
LVL 33

Expert Comment

by:Mike Eghtebas
ID: 40440411
Thank you very much.

Author Closing Comment

ID: 40442438
Awarded to both experts.  Thank you to both of you.

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
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…

919 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now