> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Archive Collection: Hidden Features
- URL: https://nolongerset.com/archive-hidden-features/
- Published: 2023-01-20T23:00:00.000Z
- Updated: 2026-05-08T12:52:12.000Z
- Description: I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Hidden Features.
- Author: Mike Wolfe
- Tags: Archive, #Import 2026-05-20 02:59

*I've been writing a daily article here since September 1, 2020; that's over 800 articles. I haven't missed a day yet, and that includes [Christmas and Easter](https://nolongerset.com/tag/holiday/). Well, I'm taking my first family vacation since I started writing this blog. Our only other family vacation (which predates the blog) was a National Lampoon's-style disaster. I hope this one is going better.*

*I'm writing this in the *present* tense, but I'm writing it for *future* publication with links to *past* articles. Let's hope the time-space continuum holds up.*

*In any case, as the slacker Firstie says to the Stony Lonesome Gate guard twenty minutes before Taps, let me get to the Point. I've got a daily publishing streak to keep up. But I don't want to be writing and publishing articles on vacation. And I still want to provide you with something of value to read each day. So I settled on creating a series of curated article lists that I think you'll find beneficial.*

*I'm hoping at least some of these articles are ones you haven't read before. And if you're so obsessed with me that you *have* read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.* 

*Enjoy!*

---

## Hidden Features

[Requery a Form in PlaceForm.Recordset.Requery. That’s it. That’s the whole article.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/10/stadium-1750794_1920.jpg)](https://nolongerset.com/requery-a-form-in-place/)

[Blast From the PastWhy use keyboard shortcuts from Access 2003 when developing in 2020? Because starting with Access 2007, the new shortcuts suck.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/10/Marilyn_Monroe_photo_pose_Seven_Year_Itch.jpg)](https://nolongerset.com/blast-from-the-past/)

[JetShowPlan: A PrimerYou may be familiar with JetShowPlan, but I guarantee you’ve never read an article about it quite like this one.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/military-raptor-582888_1920.jpg)](https://nolongerset.com/jetshowplan-a-primer/)

[Debugging Private ProceduresAfter more than 14 years as a VBA developer, I recently discovered that you can debug private procedures without temporarily making them public!![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/05/monkey-thoughts.jpg)](https://nolongerset.com/debugging-private-procedures/)

[Hidden Feature: Drag and Drop Access Objects Between FilesSkip the “Import Access Objects” dialog screens and use your mouse to move Tables, Queries, Forms, Reports, and code modules between Access files.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/12/dog-6724085_1920.jpg)](https://nolongerset.com/drag-and-drop-access-objects/)

[VBA’s Case Changing “Feature”VBA likes to change the casing of our code (upper/lower/mixed). It may seem random, but it’s not. Read all the details here.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/letters-691842_1920.jpg)](https://nolongerset.com/vbas-case-changing-feature/)

[Inspecting the End of a Long Variable Value in VBAYou 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?![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/02/line-4088057_1920.jpg)](https://nolongerset.com/ctrl-hover-over-vba-variables/)

[Quick and Dirty For Loops in the Immediate WindowDid you know that you can write and execute entire For Loops in the VBA Immediate Window?![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/02/motor-loop-3260697_1920-1-.jpg)](https://nolongerset.com/for-loops-immediate-window/)

[Poor Man’s Status Bar in VBAIf you’re looking for a quick and dirty way to keep track of a long-running process while developing, this VBA one-liner will do the trick.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/07/Poor-Man-s-Status-Bar.jpg)](https://nolongerset.com/poor-mans-status-bar/)

[Shortcut Key to Comment/Uncomment Blocks of Code in VBAYou don’t need 3rd-party tools to add keyboard shortcuts for commenting and uncommenting code blocks in VBA with this trick.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/04/Comment-Block-QuickTip.jpg)](https://nolongerset.com/block-comment-shortcut-key/)

[WizHook: A Hidden Access Object With Intriguing PotentialFont-aware AutoFit of text and combo boxes, auto-bracketing of illegal field names, sorting an array of strings...the possibilities are finite!![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/10/gandalf-4510395_1920.jpg)](https://nolongerset.com/wizhook/)

[Dark Mode in VBAVBA may not have a preset “Dark Mode” like other modern development environments, but it’s not hard to create one yourself.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/12/Dark-Mode-in-VBA.jpeg)](https://nolongerset.com/dark-mode-in-vba/)

[Declaring and Initializing Variables in the Same Line in VBAYou 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.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/02/background-906135_1920.jpg)](https://nolongerset.com/declare-and-initialize-in-vba/)

[Select Entire Sub or Function in VBA with a Double-ClickYet another hidden feature of the VBA editor that eluded me for more than fifteen years.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/11/Select-Procedure-QuickTip.jpg)](https://nolongerset.com/double-click-select-procedure/)

And there's lots more where those came from on the [Hidden Features tag page](https://nolongerset.com/tag/hidden-features/).