Capitalize 1st letter only of a word...

[mtabt]

Is there a simple way to capitalize only the 1st letter of words (names) that are being entered through a form..??

Also, is there a simple way to capitalize only the 1st letter of a SENTENCE...

I am not an expert in MS Access and not too familar with modules, please can you suggest a simple solution.

Step-by-step solution will be greatly appreciated.

Thank you very much.

 

[rhicks]

To Capitalize (ProperCase) the first letter of each word, use the StrConv() function. For more information on this, search Access Help for this function.

HTH
RDH Ricky Hicks

 

[Brambojr]

You may also want to check out the FAQ's for this forum Brambojr