Article ID: 321001 - View products that this article applies to.
This article was previously published under Q321001
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).
For more information about SQL Server data types, see SQL Server Books Online available at the following Microsoft Web site:
Contact us for more help
Connect with Answer Desk for expert help.