I have an mdb file with a table with fields that I want to allow null values in, but that I don't want to allow zero length strings in.
I have a form in a VB .NET Windows Form project whose controls are bound to this table. Some are text fields, some and comboboxes pulling lists from lookup tables.
I am building my own adapters from scratch so I can change things in code dynamically if that makes a simpler solution.
I want an empty textbox or an empty comobox (one whose display text is blank) to be considered vbNull instread of "" so they don't cause update errors on those columns which can be null but not allowing zero length strings. Perhaps there is a better solution?
How do other people handle updating nullable non-zero string length columns based on textboxes and controls whose empty values are "" and not vbNull?