I have a field on a form. The field is a text field with a length of 200. The field in the database table is navchar(max).
The form submits fine but the field in question will not accept text only numbers. I have recreated the field from scratch to avoid any issues with the existing one, changed it to html type, changed the short field name and column name in the database and cannot get it to accept any letter.
I am wrecking my brain on this one and cannot see why other fields on the form (all which are identical in the DB) and where some are identical - this one will not accept text. The table has existing data so I don't want to recreate it.