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

View products that this article applies to.

Symptoms

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

Cause

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.

↑ Back to the top

Resolution

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).

Start SQL Server Enterprise Manager, and then locate the server where the database is located.
Expand the Databases folder, double-click the database name, and then click Tables.
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.
Under Data Type, click the field that you want to modify, click the down arrow, and then click either Text or Varchar data type.
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.
Start Microsoft Access, and then open your database application.
Click Tables, and then delete the linked table that contains the field that you modified in step 4.
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.