I
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
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