Throwback Thursday: August 14, 2025

In today's edition of Throwback Thursday, we resurface some of Access and VBA's most deeply "hidden" features.

Throwback Thursday: August 14, 2025

With over a million words scattered across more than 1,500 articles on this blog, you've probably missed a few things here.

That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.


Highlights from NoLongerSet.com

Concatenating Strings in VBA: Plus (+) vs. Ampersand (&)
Both the ampersand and the plus sign operators can be used to join strings in VBA. Clever developers can use this to their advantage.
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.
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.
Debugging Private Procedures
After more than 14 years as a VBA developer, I recently discovered that you can debug private procedures without temporarily making them public!
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.
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?

Wisdom from Around the Web

Hidden features of VBA
Which features of the VBA language are either poorly documented, or simply not often used?

Developer Humor

Cover image generated by Ideogram

All original code samples by Mike Wolfe are licensed under CC BY 4.0