MS Access SQL Server ODBC Connection 255 Character Limit?

[MRG123]

My Access DB is linked to a SQL Server table that contains a NVARCHAR(MAX) field that stores Rich Text. When trying to retrieve the field from Access the text is cut off at 255 characters. Access is currently reading the Data Type as "Long Text" however, I cannot set the Text Format to Rich Text in the Field Properties window due to it being a linked table (I receive the message "Operation is not supported for this type of object").
Any suggestions on how to display more than 255 characters in Access when pulling from an ODBC connection? Below is a test of numbers to show where the text is cutting off, I made these numbers bold, but removed the bold tags to display here.
ODBC Connection INFO: SQL Server ODBC Driver Version 10.00.17763.01, File SQLSRV32.DLL
SQL Server Test Displays: 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 ,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,3 7,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53, 54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70 ,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,8 7,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102, 103,104,105,106,107,108,109,110,111,112,113,114,11 5,116,117,118,119,120,121,122,123,124,125,126,127, 128,129,130,131,132,133,134,135,136,137,138,139,14 0,141,142,143,144,145,146,147,148,149,150,151,152, 153,154,155,156,157,158,159,160,161,162,163,164,16 5,166,167,168,169,170,171,172,173,174,175,176,177, 178,179,180,181,182,183,184,185,186,187,188,189,19 0,191,192,193,194,195,196,197,198,199,200,201,202, 203,204,205,206,207,208,209,210,211,212,213,214,21 5,216,217,218,219,220,221,222,223,224,225,226,227, 228,229,230,231,232,233,234,235,236,237,238,239,24 0,241,242,243,244,245,246,247,248,249,250,251,252, 253,254,255,256,257,258,259,260,261,262,263,264,26 5,266,267,268,269,270,271,272,273,274,275,276,277, 278,279,280,281,282,283,284,285,286,287,288,289,29 0,291,292,293,294,295,296,297,298,299,300


Access Text Box and Table link only show: 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 ,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,3 7,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53, 54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70 ,71,72,73,74,75,76,77,78

[CJ_London]

rich text is a format (enables HTML formatting of fonts, indenting and the like), not a datatype.

It is not a problem I have had (other than the 4k limit) but a quick google indicates it might be your ODBC driver that is causing the problem - see this link

https://www.sqlservercentral.com/for...x-field-in-sql

[GinaWhipp]

Hmm, this might also depend on the if you are using a aggregate query to pull the data. Those will cut your data off at 255 characters.