CaseConvert

[Guest]

Iopened a MS Access 2003 database that used CaseConvert- I got errors
I commented out the code and it works - is there a CaseConvert function for
ProperCase in Access 2007?

Private Sub Address1_AfterUpdate()

' If Address1 <> "" Then
' Address1 = CaseConvert(Address1, 3)
' End If
End Sub

 

[Allen Browne]

Try the StrConv() function.