Paul,

Try simply adding one field at a time like this.

... Your given values...
Field("street") = 123 Main Street
Field("street2") = Suite 123
Field("city") = Anytown
...

var finalAddress = "";

if (Field("street") != "")
   finalAddress += Field("street");

if (Field("street2") != "")
   finalAddress += " " + Field("street2");

if (Field("city") != "")
   finalAddress += " " + Field("city");

return finalAddress;
........

This will concatenate any non-empty fields in your list to the variable finalAddress, as well as add a space when necessary. If all fields are blank, it will return a blank. I'm sure that there are other ways of doing this, but if you just need those three field looked at, to me, this is by far the simplest, most direct way.

---
David A. Sweet
Web Designer/Graphic Designer
HKM Direct Market Communications
A DirectConnectGroup Company

--
Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED] --
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm

--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--


--
Note:  All e-mail sent to or from this address will be received or otherwise 
recorded by the e-mail recipients of this forum. It is subject to archival, 
monitoring or review by, and/or disclosure to someone other than the recipient. 
Our privacy policy is posted on www.printplanet.com
--

Reply via email to