how to change upper case to proper case

[Guest]

 

[Douglas J. Steele]

Some details would be useful (that's what the body of the post is for...)

Where do you wnat to do this: in a form as the user keys the information in,
or in a table that already has the data in it?

 

[Tom Wickerath]

Adib,

Look up the use of the StrConv function.

StrConv(string, conversion, LCID)

using 3 as the conversion (vbProperCase) should do what you want. For example, in a query, you
can use:

ProperCase: StrConv([FieldName], 3)

where [FieldName] is the name of your text field.

Tom

_________________________________

news:[email protected]...

 

[Joseph Meehan]

First it is a good idea to put your question in the body of the message
not just the subject line. It is also helpful to identify the program and
version you are using, like maybe Word 2003.

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.