Where is property sheet for subreport?

[Ellen]

Hello,
I have a report with a subreport that is at times blank.
In order to eliminate blank lines I've been told:

In the property sheet for the subform/subreport
control (on your main report) that contains your
subreport, change the "Can Shrink" property to YES.

Can someone describe where I can find the property sheet
for the subreport control?

Thank you in advance,
Ellen

 

[Allen Browne]

1. Open the main report in design view.

2. Right-click the edge of the subreport, and choose Properties.
The title of the Properties box reads "Subform/Subreport: ..."

3. The CanShrink property is on the Format tab.

Note that the Detail(?) section of the main report also has a CanShrink
property.

So does the text box and the Detail section in the subreport, if you open
that report in design view (from the Database windows).

 

[Guest]

Found it! Thanks, Allen!

-----Original Message-----
1. Open the main report in design view.

2. Right-click the edge of the subreport, and choose Properties.
The title of the Properties box reads "Subform/Subreport: ..."

3. The CanShrink property is on the Format tab.

Note that the Detail(?) section of the main report also has a CanShrink
property.

So does the text box and the Detail section in the subreport, if you open
that report in design view (from the Database windows).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.