Hi,<BR><BR>Looking @ your script, your forcing to insert an empty string. I think your solution will be ok if used sparingly. However, the null value will be set if your empty fields allow null values to be stored within them.<BR><BR>Cheers<BR><BR>IQ
I think what the poster was saying is that if your database is set up to receive nulls in that field, not passing any value to it will default to NULL.<BR><BR>If that's not the case, then explicitly set the variable to null.<BR><BR>myvar = Null 'No quotes!!!!