Report columns that Can Shrink

[charles.kendricks]

Is it possible to create columns in a report that can shrink and not be
visible if the value is null or zero? I also want empty space to be
evenly distributed among the remaining columns similiar to the way
subreports can shrink.

 

[Larry Linson]

Is it possible to create columns in a report that can shrink and not be
visible if the value is null or zero? I also want empty space to be
evenly distributed among the remaining columns similiar to the way
subreports can shrink.

No, CanGrow and CanShrink only apply to the vertical space of Controls, and,
even then, only if there is no other control alongside. You could, with a
good deal of work, create your entire line in code and adjust widths on your
own. To do so, and do it well, would not be a trivial undertaking because
you'd have to be very well-versed in the metrics of fonts.

Larry Linson
Microsoft Access MVP

 

[charles.kendricks]

Thanks, At least now I can stop beating my head against the wall!