Can Shrink Yes/No Fields

[Denise]

I have been trying to design a report for weeks. I have over 50 yes/no fields in a report. I only want the ones that are checked off Yes to show up on the report. I can do this, but then my can shrink does not work right. The Yes fields that show up, show up everywhere. Any suggestions....thanks

 

[Marshall Barton]

I have been trying to design a report for weeks. I have over 50 yes/no fields in a report. I only want the ones that are checked off Yes to show up on the report. I can do this, but then my can shrink does not work right. The Yes fields that show up, show up everywhere. Any suggestions....thanks

First set the controls' and their section's CanShrink
property to Yes.

Then use code in the section's Format event:
Me.yesnoA.Visible = (Me.yesnoA = True)
for each of the yesno fields you want to shrink.