StrConv problems

[mrmetal]

I have a string that is assembled from various fields. I would like to be able to convert this string to an actual sentence - first letter of first word capitalized, with no other capitalizations.

I first tried an input mask, but because the values will be of varying length, that did not work. Next, I tried using the StrConv method, but every word gets capitalized.

Is there a way to capitalize only the first letter of the first word?

Thanks for the help

Ed

 

[alvechurchdata]

Something on the lines of:
[TT]
Ucase(Left(MyString, 1)) & Mid(MyString, 2)
[/TT]

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[ZmrAbdulla]

Geoff, can I alter a little?
[tt]
UCase (Left(MyString, 1)) & LCase(Mid(MyString, 2))[/tt]

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.

 

[SeeThru]

You can even use instr() to look for ". " (period space) and then capitalise the next character after that as well. And check if it ends in a period and add one if it doesnt.

 

[mrmetal]

Thank's guys - it worked very well. I'm trying to understand the code, however, and am confused what the numbers mean. Does it mean that:
1. the code reads the string from left to right
2. beginning at the first letter, everything gets capitalized
3. beginning at the second letter (because of the number 2 in the second part of the code) everything is converted to lowercase.

Additionally, what is the difference between Geoff's code and Zameer's code. I tried them both to see if I could tell the difference, but they both worked.

Thanks

Ed

 

[lesw1433]

Yes that is correct with the following exception

2) The first letter only gets capitalized.

The only difference is that LCase insured that every letter after the first letter was in lower case, in case someone enter a capital letter elsewhere in the string.

 

[ZmrAbdulla]

The only difference is that LCase insured that every letter after the first letter was in lower case, in case someone enter a capital letter elsewhere in the string.

True

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.