Assign Null to textbox after deleting its content

  • Thread starter Thread starter Arend Jan
  • Start date Start date
A

Arend Jan

Hi,

I have a form in which the tableadapter gets its data from an access table.
Suppose I want to delete a clients phone number. I select the text in the
phone number field, and press delete. The field is now empty.

When I try to call the update method of the table adapter, I get an OleDb
exception telling me that the field can not be an empty string.

How do I get a field to become 'Null' if I delete its contents?
Not in the Validating event of each text box I hope?

Thx,
Arend Jan
 
If you are getting the exception from OLEDb, then most likely the issue is
on the database side. The field itself is most likely defined to not allow
nulls.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Null Values eliminates the row? 6
Setting Textbox to Null for DateTime 1
Changing null to "" in a form field. 3
TextBox bound to a numeric value does not allow nulls 2
Table Field Set To Not Allow Nulls 1
Replace "assign the null value" message 1
null value in xml translates to empty string in dataset after ReadXML 1
Confusing NULL on a TextBox bounded to Hyperlink Field 3

Back
Top