convert textbox to proper case After Update

[snipe]

Hey guys,



I am trying to convert the text in a textbox via VBA using the After Update. I currently have:

Private Sub Fname_AfterUpdate()
Dim result As String
Dim field As String


field = Me.Fname


result = StrConv(field, vbProperCase)
 
field = result


End Sub

Doesn't seem to do anything though. What am I doing wrong?

[Bob Fitz]

You should only need:
Me.Fname= StrConv(Me.Fname, vbProperCase)

Have checked that the code actually fires.

[June7]

All this does is set the values of two variables. Set a breakpoint and run code. Does the procedure execute? Are the variables set?

Try simply:

Private Sub Fname_AfterUpdate()
Me.Fname= StrConv(Me.Fname, vbProperCase)
End Sub

[snipe]

Oh wow. Thanks guys.