Jack,
thanks for the news that there's a way to overcome the abbreviation substitution. And
thanks for a software solution. As an ebase/FileMaker novice, I'm not sure I'm up
for this patch. With a good backup, I might see how far I can get. At the very
least, I'll stop looking in the manuals for a way out.
Thanks,
John Andrews
At 08:48 AM 7/26/2001 -0600, you wrote:
>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
>---------------------------------------------------------------------
>
>
John Andrews
P.O. Box 852
Saco, Maine 04072
www.EasternTrail.Org
www.SacoBayTrails.Org
207-282-1979
------------------
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
---------------------------------------------------------------------
