Visible property not available in code for a report

[Gary S]

Hi,

I have a report that has several subreports in the detail section.

I want to sometimes show certain subreports and soemtimes not
based upon criteria. The problem I have run into is in code, the
visible property is not available in the on format for the detail section.
Could somebody help me solve this problem.

 

[Jack Leach]

I'm not an expert with reports, but sometimes intellisense doesn't pick up
various properties. Have you tried coding the .Visible property? It may
work even if you don't see it in the popup list.

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[JimBurke via AccessMonster.com]

I haven' t had that problem with subreports (never used them) but i know that
it can happen with controls as well. With controls, if intellisense doesn't
present you with the property in the list you can use, for example,
Me.Controls("ctlName").Visible, so I would imagine the same type of format
would work for the subreport. I would think the subreport would be considered
a control on the 'parent' report.

 

[Gary S]

Jack,

That was it, thanks for solving this problem for me!