I have a sub-report on a report that looks like this: (confidential information hidden)
The sub-report has a box around it as you can see. But here is what I need to do. If, for example, the detail has no Tax ID # or no Main Phone or if any of the fields have no information, hide the label and shrink the data fields vertically including the box around the sub-form. I do have the fields and the detail section of the sub-report set to Can Grow = Yes and Can Shrink = Yes.
Can this be done? If so, how?
and use conditional formatting to change the label text color to white where no text exists