Capitalization code Help

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

Guest

Hi any one with an Idea how to write code that capitalizes the first letter
of every word and one that capitalizes the whole statement. Very much
appreciated
 
The StrConv function should be what you are looking for. Look it up in the
help file for all the details.
 
UCase() will convert a string to all upper case.

Alternatively you can use the StrConv() Function:

StrConv(MyString,vbUpperCase) 'convert to upper case
StrConv(MyString,vbProperCase) 'capitalize first character of each word

Steve
 

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

Change the color of each capital letter in a rich text memo field. 0
Changing all Caps in a column 3
First Letter of Every Word Capitalized 4
format a text field 1
Capitalize text in a field 8
input mask - capitalize first letter? 7
All capital Letters ! 1
How do I eliminate unwanted Caps at line start of a line 1

Back
Top