Upper and Lower Case

T

Todd

Hi All,

I have problem at the moment - all the data in one field is coming up in
capital letter e.g. JOHN SMITH, what i would like to do is have only the
first letter come up in capitals e.g. John Smith

Does anybody have an idea how to do this?

Thanks

Todd
 
M

Michel Walsh

Hi,

? StrConv("hello world", 3)
Hello World


But it does just that, I mean that particular capitalization is not taken
into account.
You can use vbproperCase, instead of 3, if you are not in a query.



Hoping it may help,
Vanderghast, Access MVP
 
Top