Dennis, I do this on reports. 2 Report Variables vCR = ((char(13))+(char(10))) vAddressAll = (CompanyName + .vcr + ShipAddress1 + .vcr + (IFNULL(ShipAddress2,NULL,(ShipAddress2+ .vcr))) + (IFNULL(ShipCity,NULL,(ShipCity + ', '))) + ShipStateProvince & ShipPostalCode) IN Customers WHERE CustomerID = CustomerID Then I place the variable on the report.
Jan -----Original Message----- From: Dennis McGrath <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 8 Oct 2008 14:13:33 -0500 Subject: [RBASE-L] - Address formatting question I seem to remember something in a demo of a slick way to format a mailing address. Say the address has 6 lines. Any of the lines can be null. I’m doing some fiddling in code and variables to move lines up the pecking order so the address always formats without blank lines. Does anyone have an even better way to do this on an RBASE report? If not, don’t worry, my old stuff will work fine, but I’m always looking for more efficient ways to do things. Thanks Dennis McGrath
