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.