ACC2002: Error Message: The Text Is Too Long to Be Edited

This article was previously published under Q321001
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2000 version of this article, see 322874.

For a Microsoft Access 97 version of this article, see 322875.
If you try to type text in a memo field, you may receive the following error message:
The text is too long to be edited
This issue may occur when you try to type data in a field that has been upsized from the Memo data type in Microsoft Access to the SQL Server nText data type.
To resolve this issue, modify the data type from nText to Text or Varchar. To do so, follow these steps.

NOTE: To perform the procedure listed later in this article you must have appropriate permissions to modify database objects (db_ddladmin or db_owner).

  1. Start SQL Server Enterprise Manager, and then locate the server where the database is located.
  2. Expand the Databases folder, double-click the database name, and then click Tables.
  3. In the right pane of Enterprise Manager, right-click the table where the nText datatype field is located, and then click Design Table on the shortcut menu.
  4. Under Data Type, click the field that you want to modify, click the down arrow, and then click either Text or Varchar data type.
  5. Close the Design Table dialog box. Click Yes to save the changes that you made to the table design, and then quit SQL Server Enterprise Manager.
  6. Start Microsoft Access, and then open your database application.
  7. Click Tables, and then delete the linked table that contains the field that you modified in step 4.
  8. Re-link the table. To do this, follow these steps:
    1. On the File menu, point to Get External Data, and then click Link Tables.
    2. In the Files of Type box, click ODBC Databases().
    3. Click an existing DSN or click New to create a DSN that points to the SQL Server or MSDE that contains your table. Click OK.

      NOTE: The server may prompt you to log on. If you do not know the user ID and password, contact your system administrator.
    4. In the Link Tables dialog box, select the table that you want, and then click OK.
For more information about SQL Server data types, see SQL Server Books Online available at the following Microsoft Web site:

Article ID: 321001 - Last Review: 12/07/2015 10:35:10 - Revision: 3.3

Microsoft Access 2002 Standard Edition

  • kbnosurvey kbarchive kbprb KB321001