>1. In our database we have columns which do not allow null values (all data types except dates are not-nullable in our database).
>
>3. When we add a new row in our form, the string values are NULL unless we put values into them.

For me as a rule of thumb such a rule falls under the data dictionary rules needing to be elevated into the GUI automatically, as in providing a blank string as default value for new rows