The problem lies in the parsing fields that build the "ADDRESS\USPS FORMAT"
field. This field, in turn, is used in the "ADDRESS LINE\LABEL" field,
which appears on mailing labels. There is another field, named "ADDRESS
LINE\LETTER", which is used on envelopes and appears on your HOME
screen. The "ADDRESS LINE\LETTER" field uses whatever you've typed into
the "ADDRESS\SUPPLEMENTARY" and "ADDRESS\DELIVERY" fields without doing any
manipulations.
So, the simplest fix is to change the label layouts so that they reference
the "ADDRESS LINE\LETTER" field instead of the "ADDRESS LINE\LABEL" field.
Another solution is to create a text field named "UseUSPS?" that would
contain either an "N" or nothing at all. Put that field onto the data
entry screen. Only mark "N" in those records that you know will be
problematic. You'd then change the calculation for the field named
"ADDRESS LINE\LABEL".
It currently reads:
If(IsEmpty(ADDRESS\SUPPLEMENTARY),"",ADDRESS\SUPPLEMENTARY & "�") &
ADDRESS\USPS FORMAT
Change it to:
If (UseUSPS? = "N",
ADDRESS LINE\LETTER,
If(IsEmpty(ADDRESS\SUPPLEMENTARY),"",ADDRESS\SUPPLEMENTARY & "�")
& ADDRESS\USPS FORMAT)
The benefit of this second solution is that you get the use of ebase's
address standardization where you want it, but you can override it where
you know it breaks.
>I'm a new user with lots of progress, but I'm stuck on an automated
>abbreviation problem.
>
>When the words East or West appear in an address, ebase automatically
>changes them to E and W.
>
>One of our members lives on West Street. The ebase label reads W ST. I
>tried quotes, but the quotes are printed.
>
>Has anyone overcome this quirk?
---------------------------------------------------------------------
Jack Noll - ebase consultant and wildlife advocate
Check out a *great* program at www.beardogs.org
---------------------------------------------------------------------
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
