Lawrence, thanks for the tip on using a stored procedure to format addresses. I will use that method from now on.
John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lawrence Lustig Sent: Saturday, August 21, 2004 12:48 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Suppressing blank lines in mailing labels > Thanks Razzak, I am familiar with the process of > using IF statements to > filter out the blank lines in reports and labels. > What I meant to ask is.... > Does version 7 label designer have a checkbox (like > 6.5++) that will > automatically suppress blank lines? John, what I generally end up doing is creating a stored procedure: FormatAddress(pAddr1, pAddr2, pCity, pState, pZip) RETURN NOTE or whatever arguments are appropriate for the project I'm working on. I put my IF logic in there, and call the procedure whenever I need an address. I use the procedure in labels (naturally), but also forms and reports where I want to show the mailing address. The advantage is that if I decide to change my address formatting logic, I only do it in one place. -- Larry
