input mask for proper case on form

S

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.
 
Z

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.
Click to expand...

Private Sub Text1_AfterUpdate()

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

End Sub
 
Z

zionsaal

Private Sub Text1_AfterUpdate()

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

End Sub
Click to expand...

sorry:

Private Sub Text1_AfterUpdate()

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

End Sub
 
J

John W. Vinson

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

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]
 
Top