I started getting this error "String or binary data would be truncated." I've narrowed it down to one field, and it is only happening when the field is hidden and nothing is entered by the user. Should I be doing something else with a hidden field that doesn't require user input?
If I select Yes in the field prior the field in question becomes visible and the user answers the questiona and all works as it should. But if the user answers the No to the first question the field in question would not be displayed therefore would not get answered and I get the mentioned error.