Thanks, I've tried setting the value to Null or vbNull but neither works. As the value of this field gets sent to my MS-SQL DB and the field that is receiving this value is an integer it will not accept a null value being sent to it and put a 0 (Zero) instead.

I'm trying to find a way in the SQL Insert statement to 'skip' that field if the value is null.

So for example the last line of the SQL Statement I've used as a temp measure is like this... 
"'" & Address5 & "', '" & PostCode & "', '" & Ref1 & "', '" & OurRef & "', '" & yourRef & "', , ,'False')", cn
I'm just not sure if I can 'programme' that back in SQL statement so I have only one SQL statement instead of the two I have running at the moment.