Expose an array in MS Access - equivalent of var_dump()

Question

I have an array populated in VBA, and dont'cha know, it's really an array of arrays. So I want the equivalent of PHP's var_dump() function. Such a beautiful tool (and here, right now, I am discovering people want its equivalent for a bunch of languages.)

The VBA Locals window lets me wade deep into the Object Model, but I can't poke around in my array. No help there.

The only answer I've ever known is to design For loops and send each one-line result out to the good ol' one-line Immediate window. I'll have to explicitly declare the array in every aspect. Whereas var_dump() is self-discovering -- demands nothing, returns instant results.

I know I won't get that, and I know the answer to my question is "Forget it" (happy revision) ... but has anyone discovered something to help the VBA pilgrim?

Answer 1

You can add your array to a Watch