Experts:
I need some assistance with automatically updating field values into the proper format. Right now, I use the below VBA to change the field values upon closing a form.
For example, on the "Billets" form, I have the field [Ra_Billet_Title] automatically change to upper case. This works fine as is!
Also, on the "Staff Members" form, I have the field [All_Personal_Email] automatically change to lower case. This also works fine as is!
However, I have an address field where each word must be capitalized. So, a data entry of, e.g., "123 MAIN STREET APT 200" needs to change to "123 Main Street Apt 200".
How do I modify the 2nd update query in the Form "Staff Members" where I'm currently using the UCase? Is there something like "CCase" (CapitalizeCase)?
Thank you,
EEH
Code:********** Form "Billets" ********** Private Sub Form_Close() 'Update billet title to UPPER case CurrentDb.Execute "UPDATE T01_Billets SET T01_Billets.Ra_Billet_Title = UCase([Ra_Billet_Title]);" End Sub ********** Form "Staff Members" ********** Private Sub Form_Close() 'Update email to lower case CurrentDb.Execute "UPDATE T01_StaffMembers SET T01_StaffMembers.All_Personal_Email = LCase([All_Personal_Email]);" 'Update email capitalize each word CurrentDb.Execute "UPDATE T01_StaffMembers SET T01_StaffMembers.All_Address = UCase([All_Address]);" 'Rather than UCase, I need to capitalize each word End Sub