input mask for proper case on form

  • Thread starter Thread starter Song Su
  • Start date Start date
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.
 
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
 
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
 
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]
 
Back
Top