Move controls upwards using codes?

[Ling]

I have a problem here:
I have some controls in a report in which I have set their
visible properties to false when their values are null..
Is there any way in which I could shift the fields below
upwards to save space(Cos it's a report)?
Thanx

Ling

 

[Wayne Morgan]

Rather than hiding the controls, try setting their CanShrink property to Yes. This will
allow them to shrink to zero height when Null and the controls below will move up. This
can be done in the Properties sheet (Format tab) in design mode. For this to work, there
can't be anything else on the report that is horizontally inline with the control to be
shrunk. There is a CanShrink property for the section (i.e. Detail section) as well.

 

[Ling]

Thanx for ur help. I have tried the 2 methods but the
report did not shrink at all. There's still white space
between the visible & invisible controls.

-----Original Message-----
Rather than hiding the controls, try setting their

CanShrink property to Yes. This will

allow them to shrink to zero height when Null and the

controls below will move up. This

can be done in the Properties sheet (Format tab) in

design mode. For this to work, there

 

[Wayne Morgan]

Is there ANYTHING else in line (even partially) as you look across the report from left to
right with the control you want to have shrink down? Do you have multiple columns?

Something else you can try is to concatenate the information into a single textbox. This
will remove the white space between the lines of information, but will add it to the
bottom since the bottom line will move up, leaving space where it used to be.

This needs to be done INSTEAD of setting the Visible property to No. Are you sure the
values are Null and not an empty string?