I have a form with a single table as its record source. The form has both bound and unbound controls, and the form view is Single Form.
If in Form view I select a record and copy (using CTRL+C), then go to a new record and paste (CTRL+V), I get an error saying the field's not big enough for the data I'm trying to paste and to try pasting less. There is also a "Paste Errors" table created with the data of the record I copied. This same behavior is happening in code with the acCmdSelectRecord/acCmdCopy/acCmdPasteAppend command construct. However, if I open the table itself and manually copy/paste the same record, it is successfully appended to the table (with a new autonumber value for the primary key, of course).
Since I know the values in the bound controls are valid (because the record being copied is already on the table with all valid field values), I'm focused on the unbound controls. So a couple of general questions:
- Is this "field is too small" error a common issue that I've somehow missed all these years?
- Any suggestions or recommendation on how I would go about determining which of the unbound controls is the culprit?