RE: Hiding a Sub Report

From: Pilar (Pilar_at_discussions.microsoft.com)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 09:59:03 -0700

Did you try "Can Shrink" on the subreport's properties dialog box?
Pilar

"VBAD" wrote:

> I'm having difficulty with the following:
>
> I have a Sub Report which displays a picture for each record.I'm trying to
> hide the Sub if it contains no image. I've tried using;
> If rptPic etc.,etc. (won't continue to avoid embbaressment),
> however my VBA skills fail me.
>
> TIA
>

Relevant Pages

  • RE: Make a subreport invisible if blank
    ... Change the property "can shrink" to true in the next sections ... the section where the sub report is ... > where is a field in the query that the subreport is based ... > report unless there is a value for [PermanencyDate]. ...
    (microsoft.public.access.forms)
  • RE: Make a subreport invisible if blank
    ... "Ofer" wrote: ... > Change the property "can shrink" to true in the next sections ... the section where the sub report is ... What I'd like to do is have this subreport not appear at all in the main ...
    (microsoft.public.access.forms)
  • Sub Report creates new page
    ... did you set the can shrink to yes? ... >I have a sub report that creates a new page even though ... >the header information and then blank space. ... >I tried making the sub report about a 1/4 inch and set ...
    (microsoft.public.access.reports)
  • Hiding a Sub Report
    ... I have a Sub Report which displays a picture for each record.I'm trying to ... however my VBA skills fail me. ... TIA ...
    (microsoft.public.access.reports)