VBA code for Capitalizing Each Word

Topic

New Reply

How to capitalize each word in a text string with VBA code?
In the AfterUpdate event, I would like to capitalize each word (Title Case) in a textbox.
Thanks in advance.
Armstrong

Reply | Quote

Replies

Me.FirstName = StrConv(Me.txtFirstName, vbUpperCase)

Reply | Quote

Me.FirstName = StrConv(Me.txtFirstName, vbUpperCase)

Hi Steve,
Thanks for your quick help.
Now the biggest question: Can a form call both macros and subprocedures?

Armstrong

Reply | Quote

Now the biggest question: Can a form call both macros and subprocedures?

To be more specific, in a Form, a textbox event calls a macro and a form event (say, BeforeUpdate) calls a VBA subprocedure. Is it possible?
Armstrong

Reply | Quote

Now I’ve solved all issues.
Yes, a form can call both macros and VBA code.
The complete VBA code is shown in the screenshot.
Thanks.
Armstrong

Reply | Quote