>From my testing, I have found that I can set up an array as big as 1000 by 1000 elements and maybe bigger. Does anyone know the limits to an array size or is an array only limited by memory?

In VFP9 array size limit is 2GB. It's also limited by available memory. In VFP8 and earlier, the limit is 65,000 items.