"The text is too long to be edited."

[tylerg11]

When pasting into a text box in Access 2007, I will sometimes randomly get the following error.

"The text is too long to be edited."

The backed database tables are linked tables to a SQL database. The data type for this field is NVARCHAR (MAX). The data isn't even that long (sometimes less than 255 characters). Seems random, but possibly linked to the formatting of the copied text?

Any ideas? Thanks.

[rpeare]

Does it always happen on the same record, can you duplicate the problem on the same record consistently? if the SQL field goes longer than 255 characters how are you handling it?

[tylerg11]

No, it's random on completely different records.

The datatype is NVARCHAR(MAX) so there isn't a limit of 255 characters.

[rpeare]

There is in access, it won't show anything past 255 characters on a TEXT field, if however it's showing as a MEMO field in your linked tables that's something else and if you're trying to perform a function on a memo field you may encounter problems. So what exactly are you trying to do? Do you just have a query or report that displays the contents of the field? Or are you trying to do something with the field?