I'm creating the array (values_array) for the values from with variables in an object that either have a value or don't (empty) but when using ADO.Addnew the fields that were empty are entered as 0 (database field is long integer type) even though my Access database has these set for no default value. Is there a solution to this? I was hoping to avoid having to check each of these variables before having them added to the arrays.
Thanks
Bookmarks