Labels and hiding blank fields when printing

[akfruit]

I am designing a label template. But an example below is how to stop the printing from leaving gaps when field is empty.

EG

Director

ABC Credit Ltd

12 The Road

Town

"field is blank"

Postcode

So when I print I want it to print as

Director

ABC Credit Ltd

12 The Road

Town

Postcode

Please note I need to be able to do this for any line on the label if it is an empty field. Hope someone can help.

I am pulling my hair out!

Martin

[Genx]

Well, if you're using one calc field for this, you could just do:

If(not IsEmpty(JobPosition ) ; JobPosition & ¶ ) & If(not IsEmpty(CompanyName ) ; CompanyName & ¶)

& ....

etc.