Can you make a field shrink in a report based on the value of another field?

[travjbad1]

I am having a problem with a report. I want an entire row to shrink up to save space if all the fields in the row are null. I understand that you can use the "Can Shrink" to make a single field shrink, but how do I make the corresponding label dissapear as well and then shrink up?

[jimatqsi]

Do you want the entire row to not appear at all? You can handle in the On_Format event. Something like this

if isnull(me!txtbox1) and isnull(me!txtbox2) and ... then docmd.cancelevent
endif

Jim