3 Replies Latest reply: Jan 2, 2014 12:01 AM by Nitin Gupta RSS

    Displaying varchar(max) columns

      Hello, I have a table that has case comments like this:

       

      CaseID (integer)

      Comment (varchar(max))

       

      These comments can be quite long. I want to have a tab where I can pick a caseID and it display all of the comments. I have a list box for the caseID, my question is what is the best way to display the comments in their entirety... I have made a table box with the Comment in it, but it will only display the entire comment when I hover over it. I can set the wrap lines to diplay more lines but comments can be short or comments can be very long... If I set the wrap lines to something huge like 10000 then it works but it puts huges spaces in between the comments. They need to be able to see and print the complete comments. What is the best way to do this? Thanks.