Well, isNull and "" are recognised differently by Access, (I dont know if same applies to MySQL/ Oracle etc), I will look into it though, i think when the table is just blank, and never been updated, it is fine, however, after the update, the update inserts a blank field as "", which then when...