Changing UPPERCASE to Sentence Case

[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

 

[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.

 

[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.

 

[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.

 

[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.
.

 

[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.