Address with Blank LineS

[Rachel30]

Hi,

I have an address formula some of the fields are null I would like the empty fileds not to show on a line so all the address fields would move up.

Add1
Add2
If Add3 is Null then Add4

Does anyone know the best way to go about this it is for a letter address. Thanks Rachel

{spRenewalNotification;1.Add1}+ Chr(13) +
{spRenewalNotification;1.Add2} + Chr(13) +
{spRenewalNotification;1.Add3} + Chr(13) +
{spRenewalNotification;1.Add4} + Chr(13) +
{spRenewalNotification;1.Postcode}

 

[synapsevampire]

Right click the details section and select insert section below.

Place each address line in it's own section.

Right click each section and select format section and select the suppress blank section.

-k

 

[Rachel30]

K,

Sounds a very good and simple idea and I will keep this in mind for future. However I can not use you idea as I have a very large panel at the side of my document which passes the address and I need all of this visible any more idea. I would be greatfull thanks Rachel.

 

[Madawc]

Do a set of formula fields. Try

if not isnull ({spRenewalNotification;1.Add1})
and {spRenewalNotification;1.Add1} > " "
then {spRenewalNotification;1.Add1}+ Chr(13)
else " "

Stick them together in another formula field that should print OK (though I'm not certain if the line-skip will work when 'nested' - if it does not, you'll need to use logic to set it directly).

Madawc Williams (East Anglia, UK)

 

[synapsevampire]

Place your very large panel in a previous section and select Underlay Following Sections.

When posting I generally look for architectural solutions here, rather than deciding what will and what will not work. Note that you made no mention of this in your original post, please take the time to be thorough so as not to waste yours and other's time.

-k

 

[paulmarr]

This problem is so easy - insert each field in a text object just like you would like to see the address appear.

Then right click on text object - choose format text option - then on the Common Tab of the Format Editor - tick the bottom tick box that says Suppress Embedded Black Fields.

Cheers,

paulmarr

 

[Rachel30]

Paulmarr,

Your idea worked perfect and so simple. Thanks