input mask for proper case on form

[Song Su]

What's the input mask on the form to force proper case?

If user type LASTNAME, FIRSTNAME
or they type lastname, firstname

I want to convert to Lastname, Firstname

Thanks.

 

[zionsaal]

What's the input mask on the form to force proper case?

If user type LASTNAME, FIRSTNAME
or they type lastname, firstname

I want to convert to Lastname, Firstname

Thanks.

Private Sub Text1_AfterUpdate()

Me.Text1 = StrConv(Me.Text1, vbUpperCase)

End Sub

 

[zionsaal]

Private Sub Text1_AfterUpdate()

Me.Text1 = StrConv(Me.Text1, vbProperCase)

End Sub

sorry:

Private Sub Text1_AfterUpdate()

Me.Text1 = StrConv(Me.Text1, vbProperCase)

End Sub

 

[Song Su]

can I put in on the forms property? it's a data entry form. thanks.

 

[John W. Vinson]

can I put in on the forms property? it's a data entry form. thanks.

It's not a form property, it's VBA code. Open the form in design view; click
the ... icon by the AfterUpdate event line on the Events tab, and choose Code
Builder. Access will give you the Sub and End Sub lines, just edit one more
in:

Private Sub Text1_AfterUpdate()
Me!Text1 = StrConv(Me!Text1, vbProperCase)
End Sub

John W. Vinson [MVP]