Thank you for the reply. I don't have the option to simply widen the field in this (rare) case as not only does the return data in these fields vary greatly, but I'm exporting the same report as a PDF as well (and the requirement here is for it to fit on 8.5 x 11).

The extra rows are an issue as they interfere with users efforts to use vlookup functions or to simply click on a column to get an accurate record count.

Edited by pmjewett - 20 Mar 2019 at 8:22am

Yep, I was trying to avoid having different versions of the report to maintain. :)

Thank you though.

I didn't hold out much hope there would be an alternative solution but worth a try. Thanks again