I have two field objects on the detail band. One field object will only display the words, "Change Order 01" or soemthign similar if there has been a change order, otherwise, "" <-- nothing is displayed.

I cannot seem to get the band to collapse down, as well as the vertical lines when there is nothing to print for the one field object that displays "Change Order 01".

My exact code for this one object is:

IIF(tmpPOReport.PO_SUFFIX = "00", "", "Change Order " + PO_Suffix)

I set this object to "Remove Line if Blank", and it does not display the words 'Change Order 01' or whatever number it is, unless the PO_Suffix is other than "00". This works properly, but because I had to expand the height of the detail band in order to put in this object, the height remains constant and doesn't shrink down, as I would like it to, when the PO_Suffix is equal to "00".

If the above object disappears (Remove Line if Blank), why then does this detail band stay at the same height, thus wasting space? How can I get the one object to disappear and give up its space on the line? The other object that prints every time is the detail line item for the Purchase Order.