Eliminating blank controls

[Bill]

Hi all,

I have a problem with blank controls in a simple report. I have 3 controls
one underneath the other in the detail section for Address_1, Address_2, and
Address_3.

WHen there is no text in the Address_2 or Address_3 fields I want to salvage
the space in the report by not leaving a blank space in it.

Is this possible? I have set the CanShrink and CanGrow properties to Yes for
each control, but still have the white spaces.

Thanks
Bill

 

[Guest]

Hi Bill.
To recover the space you should set the canshrink property for the textboxs
to yes but also set the canshrink property for the bad to yes (I guess this
is the detail band).
Now, keep in mind that any labels or other fields if they are in parallel
(beside at the same level) as the empty textbox these will not go away so the
space is still taken up.
Hope this helps.
Fons

 

[Guest]

Fons,

Thank you so much. That resolved the problem. I did not set the CanSHrink to
yes in the "Details" band!

Do you know if two textboxes side by side can be shrunk down so there is no
space between them sideways?

 

[Guest]

I assume you mean that if the textbox on the left has no data that the data
from the one on the right moves to the left?
textboxes do not shrink directly horizontally. What you could do is instead
of using two textboxes use one unbound textbox instead and insert the source
as:
=[data1] & " spaces " & [data2]
There are some variant where you would replace the & with a + instead, this
would not print either if the second is null.
Glad that it worked.
Fons