In this Microsoft Access tutorial, I'm going to teach you how to use the On Activate event to highlight the active form and turn it yellow when you click on it, to make it more easily visible to the user.
Harper from Seattle, Washington (a Platinum Member) asks: Is there any way to highlight the current form that has focus? Our database uses a bunch of different forms, and sometimes it's hard to keep track of which one you're on. I know how to use conditional formatting to highlight the field you're on, but it would be nice if the whole form turned yellow too. I tried using the On Got Focus event for the form, but that doesn't seem to do anything.
BECOME A MEMBER:
KZitem: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
On Activate Event: 599cd.com/OnActivate
PREREQUISITES:
Intro to VBA: 599cd.com/IntroVBA
Variables: 599cd.com/Variables
Scope: 599cd.com/Scope
LINKS:
VBA Colors: 599cd.com/VBAColor
RECOMMENDED COURSES:
Access Advanced 1: 599cd.com/ACA1
Access Developer 41: 599cd.com/ACD41
USAGE:
Form Level Variable: Dim StartColor As Long
On Load Event: StartColor = Me.Detail.BackColor
On Activate Event: Me.Detail.BackColor = vbYellow
On Deactivate Event: Me.Detail.BackColor = StartColor
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, On Activate Event, Form Highlighting, Form Focus, Active Form, User Experience, Form Navigation, Form Activation
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Негізгі бет Use the On Activate Event to Highlight Active Form in Microsoft Access
Пікірлер: 14