I have a bound textbox that needs to never store a null value when commited to the DB, yet this is exactly what happens. What I've done to try to resolve the problem is to specifically set the text property to System.String.Empty - but a null is still stored to the DB. I know the logic is correct because I'm doing exactly the same thing to intialize a 0 to textboxes that are bound to numeric values.
If you enter text into the textbox and then clear it, a non-null value is stored to the DB, so there really should be a way to intialize the bound value to an empty string instead of null.
I'm desperate enough that I even tried such a screwy hack as to initialize with .Text = " " & Chr(10) (a space and then a backspace) --- this populated the textbox with a space and an invalid character symbox.
Any help would be greatly appreciated.
If you enter text into the textbox and then clear it, a non-null value is stored to the DB, so there really should be a way to intialize the bound value to an empty string instead of null.
I'm desperate enough that I even tried such a screwy hack as to initialize with .Text = " " & Chr(10) (a space and then a backspace) --- this populated the textbox with a space and an invalid character symbox.
Any help would be greatly appreciated.