displaying address fields without blank lines

[neemi]

Does anyone know how I can display an address without the blank lines appearing. For example if I have address1, address2, address3, address4 and postcode but address3 and address4 is blank. I want the text to display as

address1
address2
postcode

instead of

address1
address2


postcode

???

I have tried setting vertical elastisity to contract but it does not appear to work?

Any suggestions?

Cheers in advance.
Neemi

 

[nagornyi]

There are two ways to solve this problem. First one is to use formula column that would build entire address without blanks. Something like

function CF_addressFormula return Char is
v_address char(200);
begin
if address1>' ' then v_address:=:address1||chr(10); end if;
if address2>' ' then v_address:=v_address||:address2||chr(10); end if;
.......
if :postcode>' ' then v_address:=v_address||:postcode; end if;
return v_address;
end;

In the data model you will need to type in blank for the 'Value if Null" propery of all the address fields.
Another option would be to use anchors in the layout model. You may hook each lower address field to the upper one, and specify "Collapse Vertically" property for the anchors to be "Yes".