Issue with text field on linked table (1 Viewer)

[kevlray]

We have a database (Access 2007) with several linked tables to an MS-SQL 2008 instance. All the text fields that I have issue with are nvarchar(255) on MS-SQL. The odd thing it will not allow a full 255 characters to be entered into the field. It will fail to save unless the number of characters is about 238 or 239 characters (not sure of the exact number of characters). It shows the field as a text and field size of 255 in Access Any idea why there may be a limitation.

 

[llkhoutx]

The limitation is based upon the control data type, textboxes are limited. Use a memo data type which has a huge limit.

 

[kevlray]

I was just wondering if it is a nvarchar(255), how come I cannot input 255 characters?