Originally Posted by theDBguy
Hi Phil. Thanks for the correction. Do you have a list of what cannot be returned by a function, if any at all?
Right now I cannot think of any type that can NOT be returned by a function. So, no list... :-)
Of course, there are some limitations, like a Public
function cannot return a Private
type or you can only use functions returning primitive types in Access expressions. - These are no limitations of the function, but of the calling context.
Originally Posted by June7
Alternative is to global declare array object and it can be referenced from multiple procedures/modules. I have done this.
Sure, this would "work". However, the fact that any global variable can be referenced (r/w) from multiple procedures is a strong point against using it.