Changing UPPERCASE to Sentence Case

R

Roger Bell

If you have a field eg: Lastname where all the data has
been entered in all 'UPPERCASE', is there a quick way you
can change it to 'Sentence Case'

Thanks for any help
 
F

fredg

If you have a field eg: Lastname where all the data has
been entered in all 'UPPERCASE', is there a quick way you
can change it to 'Sentence Case'

Thanks for any help

StrConv([FieldName],3)

THIS WILL LOOK LIKE THIS, AND SO WILL MCDONALD.
This Will Look Like This And So Will Mcdonald.
 
A

Allen Browne

You can use StrConv() in the AfterUpdate event of the text box.

Some people don't like it though, e.g. McDonald and van Leen.
 
N

Nick Coe \(UK\)

Look up the StrConv function in Access Help. Proper case is
the one most likely to be what you want though IIRC it will
capitalise every word in a string.
 
R

Roger Bell

Thanks Fred, but where do I enter this language?

-----Original Message-----
If you have a field eg: Lastname where all the data has
been entered in all 'UPPERCASE', is there a quick way you
can change it to 'Sentence Case'

Thanks for any help

StrConv([FieldName],3)

THIS WILL LOOK LIKE THIS, AND SO WILL MCDONALD.
This Will Look Like This And So Will Mcdonald.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
 
F

fredg

Thanks Fred, but where do I enter this language?
-----Original Message-----
If you have a field eg: Lastname where all the data has
been entered in all 'UPPERCASE', is there a quick way you
can change it to 'Sentence Case'

Thanks for any help

StrConv([FieldName],3)

THIS WILL LOOK LIKE THIS, AND SO WILL MCDONALD.
This Will Look Like This And So Will Mcdonald.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

It all depends.
If you are doing this when entering data into a control using a form,
then you would code the control's AfterUpdate event:
[ControlName] = StrConv([ControlName],3)

If you are doing this to update previously entered records, you would
use it in an Update Query:
Update YourTable Set YourTable.[FieldName] = StrConv([FieldName],3);


Be aware that this may unwanted results with text that should have
more than one capital McDonald, O'Connor, IBM, as well as text that
should not be capitalized at all, e.e. cummings, van den Steen, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top