I'm using VB6 with access 2000, if i insert a record and update all is fine but then i delete some text which leaves the field empty when i try to update or move to next record is tells me that < Field"COMP_NAME" cannot be zero length string> has anyone had this problem and if so how can I resolve it.

Thank you in advance
Daryl