I have a report that I can not collapes the blanks cells. I have "Can Shrink" and "Can Grow" both set to Yes. The problem is that if there is data in one of the cells, the rest of text boxes even though empty, the section grows. I have the section set to pull by Principal investigator. If you look at the database I have attached you will see exactly what I am talking about. I need all blanks to collapes so it is all together instead of empty lines.

I have tried different things through the Query with no luck such as:
#1: Doc28-5: IIf(IsNull([Doc #28-5]),"*",[Com-Doc #28-5])

#2: Com-Doc 12-5: IIf([Com-Doc #12-5] Is Not Null,[Com-Doc #12-5] & Chr(13) & Chr(10),Null)

Both gave me the same results as if I used the original column name.

Thanks!

I tried this formula in the report and recieved (Com-Doc #2) 0 and (Com-Doc # 37) -1. However, it did collapes the text box blanks. I just probably need it fine tuned to get the text to show versus numbers.

=[Com-Doc #2] & " " & [Com-Doc #25] & " " & [Com-Doc # 37]=[Com-Doc #2] & (" "+[Com-Doc #25]) & (" "+[Com-Doc # 37])