One of my junior developers got the following error message when trying to go the definition of the VBA
Cannot jump to 'Array' because it is hidden.
I followed up with this answer:
It's a part of the VBA standard library's _HiddenModule, which is hidden by default. You can display hidden members by right-clicking in the Object Browser window and checking the box to show hidden members:
As for why the
Array() function is tucked away in the _HiddenModule...I have no idea.
The Master: Stephen Lebans
I first learned about the "Show Hidden Members" setting from Access legend Stephen Lebans, when I was trying to sink events to report sections.
Here's a sample of Stephen's code that I ended up incorporating into one of my event-handling class modules:
As Stephen says in the linked forum post, "you never know what you might find" when you start looking through an object's hidden members.
Stephen is one sly dog.
Below is a copy of the original exchange I had with one of my developers.