I'm having to dig into an old VB6 app and I don't have a lot of experience with this language.

Right now I've got a form where the controls are bound to a ADODB.Recordset. So the "DataField" property of the TextBox is set to "MyIntColumnName".

When the textbox is left empty, I would expect a null to be put into the database, but instead I am getting zeros and a foreign key violation. Is there any way to specify the binding so that empty == NULL?