[mso] Re: Access Reports & Capitalisation :VSMail mx2

Glenda and Ben,

This will give you the first letter of each word in the name capitalized and
then you can use the other functions if you only need the first or last
name.

http://www.mvps.org/access/strings/str0005.htm

James

-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: Friday, July 25, 2003 6:42 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Reports & Capitalisation :VSMail mx2


I'm often faced with this same problem. Sometimes we don't have control
over the format of the data source.  I currently do the Word thing but
would much rather have an option for dealing with the data as is instead
of having to take extra steps to clean or format each time.  If a
function or bit of code can handle the problem, then it will work every
time and those of us who deal with data for a living will be able to
save a few steps which means "THEY" can pile on more work...does seem a
vicious cycle but still, a one time fix is better than repetitive action
every time. /g

From: Weiner, Dorothy [mailto:DWeiner@xxxxxxxxxxx]=20

Wouldn't it be easier to bring the information into a word table, select
=3D the text and choose Format, Change Case, Title Case? This would
involve =3D many easy steps. Not to sound obnoxious but it would have =
been
better to =3D create two fields, firstname and lastname and you might =
want
to take the =3D time to do that now.

PS. I am a newbie here so please excuse any fumbles. (-;
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: