Character Limit in Report

[maeser]

I've adjusted the character limit in my tables but my report is still cutting off these memo fields. Do you know how to fix it?

 

[nishantd]

I had a similar problem and changing the 'Can Grow' and 'Can Shrink' property values on the report to "Yes" solved the problem. It was actually the 'Can Shrink' property that fixed the problem (I really don't understand that one).

Nishant

 

[maeser]

I had a similar problem and changing the 'Can Grow' and 'Can Shrink' property values on the report to "Yes" solved the problem. It was actually the 'Can Shrink' property that fixed the problem (I really don't understand that one).

Nishant

I've tried that and although it grows larger for some of the longer notes, it still cuts off the end. Any more ideas?

 

[nishantd]

I'm not sure as to what else you could do. Did you import this data from an Excel spreadsheet by chance? If you had in-cell carriage returns in the spreadsheet,you may need to go through the data in your tables and determine if there are ASCII characters (black boxes that represent carriage returns) scattered about in the data. I had this problem and removed them from the data, then set those two properties to "Yes" and the issue of text being cut off at the end went away.

Nishant

 

[maeser]

I'm not sure as to what else you could do. Did you import this data from an Excel spreadsheet by chance? If you had in-cell carriage returns in the spreadsheet,you may need to go through the data in your tables and determine if there are ASCII characters (black boxes that represent carriage returns) scattered about in the data. I had this problem and removed them from the data, then set those two properties to "Yes" and the issue of text being cut off at the end went away.

Nishant

I typed the information in myself. It's standard text. Something I noticed is that it's cutting off anything over 255 characters (the max for text-type fields). The problem, however, is that the fields are memo-types (max of approximately 65,000 characters) because I want to display upwards of 255 characters. So, do you know if I need to change the report so it displays memo-length entries?