Display more than 255 characters

[amrnewman]

Hi - I am sure there is a VERY simple solution to this, but I am getting v. frustrated. Have read many threads around this but am none the wiser.

I have a string field that is limited to 255 characters. When the field is inserted in to the report it displays the 255 characters. However, when I look at the corresponding field on the database front end, it dislpays all the text, which in many cases is a letter cut and pasted from MSWord and is far in excess of 255 characters! How do I display all the contents of the field?

Am using CRXI on SQL2000

Thanks, Adrian

 

[amrnewman]

I have discovered an overflow table containing remaing text and concatenated the two fields!