This suggestion doesn't actually change the data, just the display of the
data on that particular layout.
You need to use the REPLACE command to change the data. There's a
calculation function called PROPER() that capitalizes the first letter of
each word and makes the rest of the letters lower case.
REPLACE commands can be tricky if you are unfamiliar with them, so ask if
you need help.
------------------------------------------------------------
Bob LeLievre
LeLievre Information Services
List Management Services for Non-Profits
voice: 617-474-9131
email: [EMAIL PROTECTED]
website: www.lelievre.net
-----Original Message-----
From: Mark Halliday [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 4:26 PM
To: TechRocks Support
Subject: [support] RE: Capital Letters
Hi Ben,
In layout mode, select the field. Under format change Text to be Title
Case. This will make the first letter of every word Captial.
> ----------
> From: Ben
> Reply To: TechRocks Support
> Sent: Thursday, June 14, 2001 4:26 PM
> To: TechRocks Support
> Subject: [support] Capital Letters
>
> When the first and last name of a person is entered is there a way to
> make
> the first letter of the first name capital and the rest of the letters
> lower case. Also to make the first letter of the last name capital
> and
> the rest lower case unless we change it ourselves. Right now if we
> enter
> it in as NANCY JONES that is how it shows up on the thank you letters
> and
> everything else. Can I change that to Nancy Jones without going to
> every
> record already entered and changing it manually.
>
> Thanks
> Ben
>
> ------------------
> 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
> ---------------------------------------------------------------------
>
>
>
------------------
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
---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------
