This report is an Excel export data dump, 70+ fields including a text blob notes field at the end of the row. Several fields deep in the report are truncating the data when the report is run; in essence, the field is too short for the data. After researching the problem on this site, I have set the Stretch Type to RelativeToBandHeight, set the Position type to Float, turned on Print when detail overflows, etc. as indicated in other postings. I can't seem to find the combination of switches that will let the text fields take all the data the query is sending in a field regardless of the design width of the text field. Since this report is specifically designed to export to Excel, the detail band has to be set to the same height as the fields or we get extra blank rows between the data rows, which is not desirable. Also, since it is going directly to Excel, the ultimate width of the datafield is irrelevant as the user can shrink or expand Excel cells to fit the data as they see fit. With all the fields in this report - the current width of the report is over 64 inches - having to move and resize and tweak all the controls to fit the data could prove to be a huge job. Is there a simple way to expand the capabilities of a text field without having to physically resize the element? TIA, Mike
