Automatic Capitalization via VBA

[stu_c]

Hi all
I have a form with fields the user fills out, once this is done they click a button to save and close the form, in the Button I want it to automatically put the fields into the correct Capitalization, how can I do this in the VBA code?

Button name: BtnSaveNewUser (OnClick)
Field Forname: TxbForename (vbProperCase)
Field Surname: TxbSurname (vbUpperCase)

Thanks in advanced
Stu

 

[Gasman]

Perhaps Google?

VBA Upper, Lower, and Proper Case - Case Functions

This tutorial will demonstrate how to use the UCASE, LCASE and STRCONV functions in VBA. While working in VBA, you often need to convert strings into

www.automateexcel.com

 

[arnelgp]

you add code to the Click Event of the button, BtnSaveNewUser:

Private Sub BtnSaveNewUser_Click()
Me!TxbForename = StrConv(Me!TxbForename & "", vbProperCase)
Me!TxbSurname = UCase(Me!TxbSurname & "")
Me.Dirty = False
End Sub