Hi Peeps,

I am sure this is a really easy question but I don't know the correct solution. Basically I have a form with several text boxes on and if the user leaves one or more blank and I come to do the assignment to the database columns I get a conversion error.

oleDR.Item("Age") = txtage.text

If txtage.txt is left blank the above gives an error. How can I make sure that when I do the assignment it handles blank strings. If its a string column I use .ToString like so and this works for strings:-

oleDR.Item("Name") = txtName.text.ToString

Any help please,

Jiggy!