addressing problem

[ian]

Hi,

Thanks for your help in advance.

I have a clients address in 6 fields, however I would
like to put it into 1 field for printing.

I have name, add1,add2, city, state, zip and can get into
one line within the field but i need each to start on a
separte line witin the field.

eg

Name = Mr Jack Benny
Add1 = 123 Street
Add2 = Newton
City = Richmond
State = Vermont
Zip = VT

Becomes:

AddP = Mr Jack Benny
123 Street
Newton
Richmond
Vermont
VT


So far I have got

AddP = Mr Jack Benny 123 Street Newton Richmond Vermont VT

also i would like to omit a line if it is blank

 

[Allen Browne]

Answered in m.p.a.formscoding