[mso] Re: Access Reports & Capitalisation



Second attempt - sent as plain text this time

Glenda,

to split a field such as "FRED BLOGGS" I used the following in a control:

=Left([SITE_MANAGER],InStr([SITE_MANAGER]," "))


This would produce "FRED"

I then referred to this control using the Proper function posted earlier
like this:

="Dear " &
IIf(IsNull([SITE_MANAGER]),"Sir/Madam",proper([SITE_MANAGER_FIRST_NAME]))

This would then produce "Dear Fred" or "Dear Sir/Madam" if the
[site_manager] field is empty.

That works for me! :)

Cheers

Ben Wilson-Mawer
Social Services
Nottinghamshire County Council



-----mso-bounce@xxxxxxxxxxxxx wrote: -----

To: <mso@xxxxxxxxxxxxx>
From: "Glenda Wells" <gwells@xxxxxxxxxxx>
Sent by: mso-bounce@xxxxxxxxxxxxx
Date: 25/07/2003 02:41PM
Subject: [mso] Re: Access Reports & Capitalisation

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
*************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager via NCC Help Desk (0115) 9772010.

This footnote also confirms that this email message has been swept
for the presence of computer viruses.

Nottinghamshire County Council Legal Disclaimer



*************************************************************
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: