We have had to use a formula to display the content of those fields in their entirety. ToText(fieldname) I hope that works for you. On Dec 19, 2014 5:55 PM, "Cristina Lichauco" <[log in to unmask]> wrote: > Hi everyone - > > We are having an issue with certain TMS fields being truncated around 250 > characters when used in Crystal Reports. GS support has not been able to > figure it out. > > The affected text fields include Curatorial Remarks, Conservation Overall > Testing & Analysis, Text Entries, among others. Any attempt to pull these > into a Crystal Report (even the stock ones) ends with the field contents > being clipped. These are fields where we often have lengthy text, so it is > a problem. > > Other text fields, for example the Conservation Line Item text fields, are > not affected. > > Has anyone else experienced this and been able to identify where the > problem may be? > > Cristina Lichauco > Collections Database Administrator > Asian Art Museum > 200 Larkin Street > San Francisco, CA 94102 > (415) 581-3676 > > CURRENTLY ON VIEW > *Roads of Arabia: Archaeology and History of the Kingdom of Saudi Arabia* > October 24, 2014 – Janaury 18, 2015 > http://www.asianart.org/exhibitions_index/roads-of-arabia > > SEARCH THE COLLECTION: > http://searchcollection.asianart.org/ > > > To unsubscribe, send an email to [log in to unmask] with the > following commands in the body of the email: > > signoff TMSUSERS > > // eoj > > You will receive a confirmation that your subscription has been removed. > To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.