Concenate Address

[sdimaggio]

How do get an address to not leave a blank line in an address?

Field1: Name
Field2: Address1
Field3: Address2
Field4: City State Zip

When all the fields contain data it looks like this when I put all the fields on a report which is a letter:

John Smith
123 Main Steeet
Suite 100
Anytown, MI 98765

If it does not have a suite number it looks like this:

John Smith
123 Main Street

Anytown, MI 98765

How do I get rid of the blank line when a 2nd address is blank. I want the address to look like this:

John Smith
123 Main Street
Anytown, MI 98765

 

[jhall156]

On the report set the control's CanShrink property to Yes, there are lots of things to know about this property, check it out in the help files. JHall

 

[sdimaggio]

Worked like a charm.

Thanks

 

[kcsteve]

Would you be Sal of K.C.MO.? Steve Foster here.