Hidden field labels keep report section from shrinking
Posted on 2004-09-17
I have a report in which I'm using the following to hide labels if a field is empty:
If IsNull(Phone) Then
PhoneLabel.Visible = False
PhoneLabel.Visible = True
I have this set for several fields and it works great to hide those labels if there are no contents in the field, however the end result is a lot of white space before the start of the next report section, even though I have everything set to Can Shrink. The labels don't have that option, so what do I do to get them to not keep the detail section from shrinking to only the fields that contain data?