Array Size

[fmrock]

Is there any way to make an array size greater then 1000? The report is getting an error when it reaches 1000

Redim Preserve strQC_Array[Count(strQC_Array) + 1]

 

[synapsevampire]

Not that I'm aware of.

However you might switch to a secondary array once you hit 1000 by testing for ubound(yourarray), which is the size of the array.

I suspect you should post technicqal information and requirements, perhaps there's a better means than using arrays, they can skewer performance.

-k

 

[fmrock]

Thats what I thought, this is just a temp solution anyways until we can develop another solution.

Thanks for your help synap.