October 7, 200619 yr 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
October 8, 200619 yr 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.
Create an account or sign in to comment