Custom MsgBox in Access. Part 6: Default Button

In this Microsoft Access tutorial series, we focus on creating a custom message box using VBA, enhancing the standard MsgBox function.

In Part 6, we will learn how to set the Default and Cancel buttons. This way if you have a "Yes/No" box and you don't want the default option to be "Yes" then you can change it to "No." This would be important if you are asking the user "are you sure you want to delete all of these files?" and you don't want him accidentally hitting ENTER for Yes. We'll also learn how to reference controls on a form using the Me.Controls collection.

Members

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

•  Database 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

• Custom MsgBox, Part 1
• Custom MsgBox, Part 5

Links

• MsgBox Options

Recommended Courses

• Access Developer Courses

Coming Up

• Custom MsgBox, Part 7

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 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 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Custom Dynamic MsgBox, Custom MsgBox in Access, default button, cancel button, default button 1, default button 2, default button 3, me.controls collection, me.controls("field") notation