Make subform not visible on my Report with code

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

Guest

I have a report with several subforms (I did not design this mess). One of
the subforms is not only a subform on a reoprt but it is also nested into
another subform on the same report (it looks like it is). What I need is to
have that suform not show if the option box on my main form is false. The
comments work correctly however I have a blank section (page on report) where
the comments use to be. This could be a 1/4, 1/2 or a full page depening on
how many comments I have. Can someone direct me to the correct solution

Here is my code..

If Forms!frmMain!Comment = True Then

Me.[rsubJoseReport-InProcessComments].Visible = True

Else

Me.[rsubJoseReport-InProcessComments].Visible = False

Me.[rsubJoseReport-InProcessComments].Height = 0

End If
 
TKM said:
I have a report with several subforms (I did not design this mess). One of
the subforms is not only a subform on a reoprt but it is also nested into
another subform on the same report (it looks like it is). What I need is to
have that suform not show if the option box on my main form is false. The
comments work correctly however I have a blank section (page on report) where
the comments use to be. This could be a 1/4, 1/2 or a full page depening on
how many comments I have. Can someone direct me to the correct solution

Here is my code..

If Forms!frmMain!Comment = True Then

Me.[rsubJoseReport-InProcessComments].Visible = True

Else

Me.[rsubJoseReport-InProcessComments].Visible = False

Me.[rsubJoseReport-InProcessComments].Height = 0

End If
Click to expand...


Setting the Height to 0 won't help here.

I think (never tried it with subform instead of subreport)
all you need is set both the subform control and its
section's CanShrink to Yes. This way, the report should
reclaim all the subform's space when it is invisible.
 
Back
Top