Creating an array with no elements

[Waud]

This is starting to irritate me so if some could tell me if this should work in Access 2003 I'd appreciate it

I'm sure I've done this in the past by declaring an array like this.

Dim myArray(-1)

But I can't remember what I was using at the time (VB5, 6 or VBA or something else)


The idea behind doing this is that I can use UBound to find how large the array is and not have to worry about trapping for err 9

 

[LNBruno]

I thought it was just

Dim myArray()

without the -1?

< M!ke >