I'm having a weird problem. I have three fields that I need to repeat on a page - two are nvarchar, one is ntext. I can repeat the ntext field if I don't include either of the others, OR I can repeat the others but not with the ntext. What's going on? Can I change the field type from ntext to another large format and bypass the problem, or is there another solution? Lock type maybe? It's a message board I'm building, if that helps.

Thanks in advance,
Eric

Edited by - eswelsh on 26 Oct 2003 17:39:47

Hehe, solved it myself. For anyone who goes searching for this problem later, here's the solution: change the cursor location to "3". Should work with memo fields in Access, too, I would think.

Hi,

Reply on an old issue that you posted :

I'm having exactly the same problem now.
How can I change the "cursor location" to 3 ?

Thanks,

Wim

Wim Conix
www.image-belle.com

Hi,

I changed the datatype to nvarchar(max) and all large textfield problems are solved.
This is only available in SQL Server 2005 !

Greetzz,

Wim

Wim Conix
www.image-belle.com