Easy SQL/VB question 1

[sdand]

I have a simple VB/SQL Server problem, which is driving me nuts.

I want to reset a (non-Key)SQL field back to a Null value, from inside a VB form. I have tried changing the textbox value and tried changing the recordset directly, with no success. Here is what I have tried, all of which produced an error:

txtfield.text=""
txtfield.text=Null
adorecordset.recordset("FieldName&quot=Null
adorecordset.recordset("FieldName&quot=""

Any help would be greatly appreciated. [sig][/sig]

 

[Vince]

you can set the field back to null if the field allows nulls by doing the following

RS.fields("Field&quot.value = vbnull

I hope this helps
[sig][/sig]

 

[sdand]

Vince:

Thank you very much for your help.

Scott [sig][/sig]