ACC: "Couldn't Insert or Paste; Data Too Long for Field" Error Message

MORE INFORMATION

You do not receive the error message until you enter data in a record because the record is not marked for saving to the table until you make some change to the record.

This error will also cause a "#Error" message to be displayed in the field whose default value exceeds its FieldSize property setting.

Steps to Reproduce Behavior

1. Start Microsoft Access and open any database.
2. Create and then save the following new table:
   

         Table: Too Long
         -------------------------
         Field Name: One
            Data Type: Text
            FieldSize: 5
            DefaultValue: Too Long
         Field Name: Two
            Data Type: Text
   						

3. Create a form based on the Too Long table.
4. View the form in Form view, and type any data in the Two field. Note that you receive the error message mentioned in the "Symptoms" section.