Can Shrink

[awach]

I have a report with a subreport where all fields have "yes" for "can shrink"
property. The control is =IIf([Allocation]=0,Null,[Allocation]) and similar.
However they aren't shrinking. How can I fix this?

 

[Rick Brandt]

I have a report with a subreport where all fields have "yes" for "can
shrink" property. The control is
=IIf([Allocation]=0,Null,[Allocation]) and similar. However they
aren't shrinking. How can I fix this?

Do they have any controls to their left or right? Do they have attached labels?
Those will both prevent shrinking.

 

[awach]

They do have controls to their right and left but no labels. However, all
the control are set to be null if [Allocation] is null so I'm not sure how to
deal with this issue. Any ideas?

I have a report with a subreport where all fields have "yes" for "can
shrink" property. The control is
=IIf([Allocation]=0,Null,[Allocation]) and similar. However they
aren't shrinking. How can I fix this?

Do they have any controls to their left or right? Do they have attached labels?
Those will both prevent shrinking.

 

[Rick Brandt]

They do have controls to their right and left but no labels.
However, all the control are set to be null if [Allocation] is null
so I'm not sure how to deal with this issue. Any ideas?

If all of the controls are Null at the same time then they should shrink. Is
the report section they sit in also set to CanShrink = Yes?

And within the "band" that extends from the top of the top-most control down to
the bottom of the bottom-most control there are NO other objects right? No
lines, boxes, images?

 

[awach]

The sections controls were off. Thanks!

They do have controls to their right and left but no labels.
However, all the control are set to be null if [Allocation] is null
so I'm not sure how to deal with this issue. Any ideas?

If all of the controls are Null at the same time then they should shrink. Is
the report section they sit in also set to CanShrink = Yes?

And within the "band" that extends from the top of the top-most control down to
the bottom of the bottom-most control there are NO other objects right? No
lines, boxes, images?