Access Change Case to Title help

Prob being really thick, but, does is there a way to change access case to Title.

I conduct a mailmerge from selected records but as usual, all different people input to the database therefore caps, lower case etc used. Looks crap without manual intervention at present so looking to control.

:)

Quote:

---

Originally Posted by fishyface

Prob being really thick, but, does is there a way to change access case to Title.

I conduct a mailmerge from selected records but as usual, all different people input to the database therefore caps, lower case etc used. Looks crap without manual intervention at present so looking to control.

:confused:

---

If I understand you correctly, use this function on the first and last names:

VB Code:

'This will uppercase the first letter of a word and lowercase the rest
Private Function CapitalizeFirst(strName as String) As String
  If strName = "" Then
    Msgbox "Invalid name"
    Exit Function
  End If
  strName = Left(UCase(strName), 1) & Right(LCase(strname), Len(strName) - 1)
  CapitalizeFirst = strName
End Function

try
myname = format(myname, vbPropercase)

pete