Mario,
Here are comments from prior postings of the same subject.
if(Right(Field("COMPANY NAME#"), 1) == "s")
return "’";
else
return "’s";
I would also put in a rule to
check if the company name already
contains the ’ character. If a
company's name in already entered in as
McDonald's, you don't want it to
say McDonald's'.
Yes, David's caveat is important. I would add that you should also
check for the presence of an existing regular, or "non-curly,"
apostrophe character (') in addition to an existing "curly" single quote
character (denoted by the "’" entity).
Also, grammatically speaking, it's not always correct to simply put an
apostrophe at the end of the possessive form of the base word, even if
the base word ends with an "s." As with all things grammatical, there
are multiple schools of thought, and there's not always one "right"
answer. However, under the more traditional, "formal" rules, the "s'"
ending is generally only appropriate if the base word is plural, and if
it's singular, it's actually correct to end with "s's". For example,
the possessive form of the plural "costumers" would be "costumers'", but
the possessive from of the singular "Chris" would be "Chris's", NOT
"Chris'". (Think about how you would pronounce this: it would be like
the general plural form "Chrises," with a distinct extra "s" syllable.)
This is yet another example of how the often-arcane rules of grammar,
especially in this strange language of English, cannot always be reduced
to precise logical algorithms. My advice, as always, is: Know thy data!
For reference:
http://en.wikipedia.org/wiki/Apostrophe#Singulars
and
http://owl.english.purdue.edu/handouts/grammar/g_apost.html
and many other pages.
Dan
Larry Whiting
Rastar Digital Marketing
[EMAIL PROTECTED]
T801-990-6421
C801-558-5316
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Calling all FP Web Users!
Do you have a question or lots of knowledge to share about FusionPro Web?
If so, join our Printable Web to Print Users' Forum today!
Send email to [EMAIL PROTECTED] to find out how!
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
Users of FusionPro Desktop have unlimited free email support. Contact Printable Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the recipient.
Our privacy policy is posted on www.printplanet.com
--
