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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upper/Lower case query 4
From large to small letters 4
Strconv function 4
Text Split 2
creating a flag to identify first, second time etc someone has app 2
Excel Comparing two columns 1
Move the last data in a new field 6
upper case lower case 0

Back
Top