make my subreport disappear

[mrMika]

I have a report with an unbound subreport in it. I would like to make the report go away in certain instances. If I make it invisible it still takes up the space but now is not visible. I can't seem to shrink it either? Any Ideas?

 

[SBendBuckeye]

Hide the subform container on the main form and then set the subform container properties as follow after you save the original values to redisplay it later:

left = 0
top = 0
width = 50
height = 50

This will at least get it out of the way for resizing the form. Hope this helps to get you started.

Good Luck!

 

[mrMika]

Thanks for the input but I'm still running into probs....

I was thinking about doing this on the print event of the form (that's where I make it invisible). However, I can't set the property after the printing has started. Also, if I try it on the "On the load event" I get an invalid reference message. Any Ideas?

 

[mrMika]

thanks for the idea but I found out why this report was not working. A property in the report header called "force new page" was set and was messing things up. Thanks again for your suggestion.