Or if you want to add recordset value to a Textbox, you can use this trick:
Code:
Text1.Text = "" & rs("FieldName").Value
This way you won't get an error saying that you cannot assign NULL to the Textbox.