Fix Hover Color on Pressed Toggle Buttons in Access

In this Microsoft Access tutorial I will show you how to fix the issue with toggle button hover colors not working after the button is pressed. We will learn how to use unbound toggle buttons and some VBA code to swap buttons and maintain the hover effect regardless of the button state, allowing you to display different colors for pressed, unpressed, and hover states.

James from Wichita, Kansas (a Learning Connection Member) asks: I'm trying to set up a toggle button that changes from green to red depending on its state, and shows yellow when the mouse hovers over it. The hover effect works fine when the toggle is in its default (unpressed) state, but it doesn't work once the button has been selected. The text on the toggle changes correctly between "Rehire" (green) and "Do NOT Rehire" (red), but the yellow hover color stops working after the button is pressed.

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA

Links

• On Current
• SetFocus
• AfterUpdate

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, toggle button hover fix, VBA hover color, toggle button color change, Access toggle button hover, hover not working after click, toggle button VBA code, VBA toggle button hover effect, toggle button events, unbound toggle button, Form Current event, SetFocus VBA, visible toggle buttons, toggle button custom colors, toggle button after update, two toggle button method, toggle button usability, VBA button swap, pressed hover workaround, toggle button properties