I am working with a form and I would like to know why SQL Server 2000 will only accept varchar and up to 8000 characters when I need to have text. When I go to my form to view it and I have in the database text, it will not show text. If I switch back over to varchar it will show the information on the form. I would like to know how can this problem be solved when I need text as I have a large amount of text inside of varchar?

Thanks,

can you post your code?

hey,
try to find solution through google.