capitlization of the first letter of words in a form text box?

[Guest]

user will enter text usually in one case or another. i would like to try to
format it to cap the first letter of each word.

 

[Allen Browne]

Mcdonald, O'brien, and everyone from Usa will not be happy with that.

You can use the AfterUpdate event of a text box to StrConv() the text, but
it the results are usually less than satisfactory.

 

[Guest]

I agree there are problems with programming the conversion to force "Title
case" in Access, but the following code works:

Option Compare Database
Option Explicit

Function Proper(strToChange As String) As String
' Converts string to Proper case
On Error Resume Next
Proper = StrConv(strToChange, vbProperCase)
End Function