Text too long to be edited

[ksaab]

I have an Access form linked to two SQL tables, I had to make a change to the field length/datatype of a field named notes. The form now tells me that the "text is too long to be edited" whenever I try to add data to that Notes field in my form. I went from char to nvarchar... how do I fix this?

 

[Kodo]

change the datatype to Text.

 

[iazcac]

If you want more than 255 char in a field, change to a memo field

 

[ksaab]

I tried text, didn't like it but it did accept ntext - is this a difference I should be worried about in SQL?