I have a text box control on a form, writing to a short text field in a table. The short text field has a field size of 50 characters; the error occurs when I enter a single character in the field. I can accept the error, and proceed entering data, which does populate the field. However, I need to distribute this form to hundreds of users, and would like it to work cleanly.
Searching around, I see people encounter this error if:
- they mix up the field/values order in an insert statement; however, I am simply trying to manually enter data in a text box control
- they experience "corruption" of the control or field, and suggest removing and replacing; I have tried both with no luck
- the field is set as a lookup field and the wrong data type is being written; however, this field has a display control of text box
I have a Before Change data macro populating another field by operating on this field's value; however, I have the same error occurring with a second table/form/field that does not have a Before Change data macro.
Any suggestions would be greatly appreciated.