Doug,
Locate ln3 and ln4 on your label
create the var csz = (city + ',' & state)
cusad2 is the 2nd address line in your customer table (which may be null)
ln3 = (ifeq(cusad2,null,.csz,cusad2))
ln4 = (ifeq(cusad2,null,' ',.csz))
Bernie Lis
----- Original Message -----
From: "Doug Hamilton" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Saturday, September 17, 2005 11:50 PM
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.
================================================
