Upper and Lower Case

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top