blank field in address details

[S.Dickson]

I have a report that create an invoice which displays the folloing
fields from the table

Name
Address1
Address2
Address3
Address4
PostCode

When i create the report all the data appears in the right place, the
only problem is that is the customer has a short address and i do not
use Address4. i end up with a blank gap between Address 3 and Postcode.
This does not look very good.
Is there a way so that if Addess4 is blank then Postcode moves up and
does not leave a gap

 

[Allen Browne]

In report design view, set the Can Shrink properties of the text boxes to
Yes.

Provided there is nothing beside or overlapping them, they will then move
up.

Make sure the Can Shrink property of the (Detail?) section stays at No if
this is something that must remain a fixed height (e.g. an address label.)

 

[Guest]

You can set an unbound control on the report and in the control source :

=IIf(IsNull([Address3]),[Address4],[Address3])

if address3 is null then address4 is shown, you will have to set address3
and 4 controls to not visible and then set a control that displays address4
if address 3 does contain data. you can do all this in the code by setting
control visible or not and by using the iif check to set the controls
correctly.

 

[S.Dickson]

Thanks very much for that

In report design view, set the Can Shrink properties of the text boxes to
Yes.

Provided there is nothing beside or overlapping them, they will then move
up.

Make sure the Can Shrink property of the (Detail?) section stays at No if
this is something that must remain a fixed height (e.g. an address label.)