Quick Tip How to Duplicate a Line of Code in VBA It's not quite a single shortcut key, but it's nearly as efficient.
Hidden Features Dark Mode in VBA VBA may not have a preset "Dark Mode" like other modern development environments, but it's not hard to create one yourself.
Hidden Features Access End-User Shortcuts Shortcut keys to toggle the dropdown state of a combo box, copy field values from the previous record, enter the current date and time, and more.
Hidden Features Select Entire Module in VBA With Control + Click Learn 4 different ways to select the entire contents of a VBA module, plus a bonus keyboard shortcut tip for switching between two active code modules.
Hidden Features Select Entire Sub or Function in VBA with a Double-Click Yet another hidden feature of the VBA editor that eluded me for more than fifteen years.
Hidden Features WizHook: A Hidden Access Object With Intriguing Potential Font-aware AutoFit of text and combo boxes, auto-bracketing of illegal field names, sorting an array of strings...the possibilities are finite!
Quick Tip Adding References from VBA Did you ever wish you could bypass the Tools > References dialog entirely when adding references in Access? Automate the process with some simple VBA.
Hidden Features AccHitTest: Returns the Form Control the Mouse Clicked On This undocumented form function can help you write a generic click event for label controls.
Hidden Features VBA Immediate Window Line and Character Limits Don't take my word for it (or anyone else's on the internet, for that matter). Prove the limits to yourself with some simple VBA.
Debugging Breaking Down Windows Error Codes Did you know there is a method to the madness behind those crazy-looking VBA error numbers like 0x80070005 or its decimal equivalent -2,147,024,891?
Hidden Features HOW TO: Run Scheduled Tasks with Microsoft Access This underused MS Access command-line argument opens up a whole new world of possibilities when it comes to scheduling recurring tasks in Access.
Quick Tip Quick Tip: Set Next Statement with Mouse Try this tip the next time you use the Edit & Continue feature when debugging. After more than 15 years of developing VBA, I'm still learning new things.
Hidden Features Why Does My Access Web Browser Control Default to IE 7? If web pages don't look right on your Access web browser control, it might be due to a little-known registry setting.
VBA Static Functions and Subs After fifteen years of writing VBA, I'm still learning new features of the language. Even if they're not particularly useful features...
Quick Tip Shortcut Key to Comment/Uncomment Blocks of Code in VBA You don't need 3rd-party tools to add keyboard shortcuts for commenting and uncommenting code blocks in VBA with this trick.
Hidden Features How to Show Hidden Items in the VBA Object Browser One possible fix for the "Cannot jump to '|' because it is hidden" error is to show hidden members in the VBA object browser.
Hidden Features Declaring and Initializing Variables in the Same Line in VBA You can't declare and initialize a variable in a single code *statement* in VBA, but you can do it in a single *line* of code with this handy trick.
Hidden Features Inspecting the End of a Long Variable Value in VBA You know how VBA cuts off the right side of a really long variable when inspecting its value via mouse hover? Did you know you can show the right side instead?
Hidden Features Quick and Dirty For Loops in the Immediate Window Did you know that you can write and execute entire For Loops in the VBA Immediate Window?
Quick Tip Inserting a Blank Line in the VBA Immediate Window Did you know you can insert a newline character in the Immediate Window without executing the current line of code?
Hidden Features Access Error Number Message Lookup Did you ever come across an error number in your Access code--maybe in an If or Select Case statement--and wonder what it was for? Wonder no longer.
Hidden Features DefType Statements in VBA: The Dark Side of Backward Compatibility Young VBA programmer, be not tempted by the dark side. DefType statements must be understood, but never used!
Intermediate The IIf() Function vs. The IIf() Statement They may look identical, but there is a very important difference in how they get evaluated.
Hidden Features Hidden Feature: Drag and Drop Access Objects Between Files Skip the "Import Access Objects" dialog screens and use your mouse to move Tables, Queries, Forms, Reports, and code modules between Access files.
Hidden Features Expressions vs. Code: Implicit Type Conversion In Microsoft Access, is a whole number literal implicitly treated as a Long or an Integer or a Double? As it turns out, it depends on where you ask.