Can I enter a null value into an array?

[striker73]

I have been trying to use an array to hold temporary variables, but sometimes the variables are null and my array doesn't seem to like this. Any ideas on a work around? Thanks!

 

[striker73]

I guess I could check to see if the value is null and then enter a space in the array.

 

[gwinn7]

A variant should accept a NULL value. Or, you can do something like...

MyArray(1433) = Nz(rc.Fields(0),"&quot

Gary
gwinn7