> 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
