Formula to format address

[kv444]

Hi,

I need to write a formual to format the address in crystal reports

for example if the adress is

john adams
123 ohio st
apt 24
cincinati ohio


i should be able to print the whole address in the reoprt and for the same report for a different recepient if tha address is

quicny
123 ohio st
cincinati ohio
I should be able to print the above adress too. I need to write a general formula so that the adress can be formateed accordingly.



Thanks for your help in advance !

 

[IanWaterman]

Just use a text box and layout fields as required

Right click text box select format at bottom check suppress embedded field blank lines

Ian