Doug, I have successfully used the ifexists command to do what you're trying to do.
(ifexists(addline2,addline2,(city + ',' &state))) (ifexists(addline2, (city + ',' & state), ' ')) -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hamilton Sent: Saturday, September 17, 2005 11:50 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Supressing blank lines in labels I want to supress blank lines in labels - typically AddrLine2 is null and would like to move the City/State/Zip line up when that is the case. R:Base Help and FTE 11/03 have solutions using code and Mike B posted a stored procedure in Feb 04. But I thought since then I'd seen a posting about feature in Labels that would automatically close blank lines but can't recall it or find an example in ConComp. I'd apreciate any help. Tnx, Doug --- RBG7-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
