Can Shrink Yes/No Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Denise said:
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
Click to expand...


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.
 
Back
Top