Empty Fields

[NUWildcat]

I have some empty fields on some of my reports, and I was wondering if there was a way to make them invisible along with their labels if the field was empty. Is this possble?

 

[Sohaila Taravati]

Set the Can Shrink property of your text box to true

Sohaila

 

[NUWildcat]

Thanks, but for some reason that didnt work. Is there some other place on the report that I need to change the properties or layout to allow that to occur?

 

[kavarin]

Is your report based on a query? If so then you should be able to incorporate an expression into it that will hide it if the value is NULL

 

[NUWildcat]

Yes it is based on a query, how do you go about doing what you said?