7 Replies Latest reply on Nov 24, 2015 7:42 AM by skywillmott

    Remove blank address fields?

    jackmac

      Hi all,

       

      I'm trying to print address labels (got that bit easily enough) but I'm struggling with the empty fields.  There are over 500 addresses in the system and it has Address1, Address2, Address3, Town etc.

       

      Some of the fields are empty as the data has been input by different people over the years.  The label at the moment has fields:

       

      Name

      Add1

      Add2

      Add3

      Town

      Postcode

       

      Is there a way to remove a field if it's blank (empty). I can create a concatenated field while will add the fields into a string but it will still show empty spaces. The only way I can think at present is to useIF and ISEMPTY() on the string. Any ideas?

       

      TIA

       

      Jackmac