Hello All, first post here, but I've tried searching for a solution with no results. Hopefully this is something easy.
I'm using CR 10. I have an Excel data sheet that I download every day. The column titles are always the same, but the data changes. One column in th sheet is a "Description" field. Sometimes the first record in this column is short, sometimes it is long. On a given day, the first cell could be 100 characters long, and the second could be 2000 characters long.
I use CR to format this data and export a PDF.
Problem
On the days that the first record in the "Description" column is short, CR defines the field as a (String), thus limiting the whole column to 255 characters. This truncates the other records in the field that may be >255.
If the first record in the field is >255, CR sets the field type as (Memo) and everything is great.
So, how can I permanently define this field as a Memo type?
IP Logged