Use VBA StrConv to Convert Uppercase Text to Sentence Case in Microsoft Access
Question details
The user needs to convert uppercase text stored in Microsoft Access to sentence case by using VBA StrConv together with additional logic that capitalizes only the first character and lowercases the remaining text.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A user is editing or updating an Access text field and wants values such as "HELLO WORLD" to appear as "Hello world" without manually retyping each entry.
- Observed behavior
- Access StrConv supports uppercase, lowercase, and proper-case conversions, but it does not directly return sentence case; additional VBA logic is required.
Before adding the VBA, open the target form or table in Design view and identify fields that may contain abbreviations, acronyms, or proper nouns that must not be lowercased.
Use a Form Control AfterUpdate Event to Convert Text to Sentence Case
Use this method when users type or paste uppercase text into an Access form and you want the field corrected immediately after the control is updated.
Access StrConv with vbProperCase capitalizes every word, which can change acronyms such as "NASA" to "Nasa". Sentence case requires lowercasing the full string first and then capitalizing only the first character.
In Access, right-click the form in the Navigation Pane, choose Design View, and select the text box control that should receive the conversion.
With the text box selected, open the Property Sheet, click the Event tab, and click the After Update event box.
Click the build button (...), choose Code Builder, and enter: Private Sub YourControl_AfterUpdate() Me.YourControl = UCase(Left(Me.YourControl, 1)) & LCase(Mid(Me.YourControl, 2)) End Sub
Save the form, switch to Form View, type uppercase text into the control, and press Tab or Enter to trigger the AfterUpdate event.

Use an Update Query with a VBA Function to Convert Existing Records
Use this method when you need to change values already stored in a table and can review affected rows before running the update.
Use WPS Office as a Free Alternative for Everyday Office Files
WPS Office does not include Microsoft Access, so it cannot run this Access VBA routine directly. For daily document, spreadsheet, and presentation work, WPS Office is a free and lightweight Microsoft Office alternative with familiar menus, strong format compatibility, and smooth file migration.
- 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
- 2. Install and launch WPS Office: Run the installer, follow the on-screen prompts, and open WPS Office from the Start menu or desktop shortcut.
- 3. Open Microsoft Office files: Click Menu, choose Open, select a Word, Excel, or PowerPoint file, and edit it with the familiar ribbon tools.

Frequently Asked Questions
Does Access StrConv convert text to sentence case directly?
No. StrConv supports vbUpperCase, vbLowerCase, and vbProperCase. For sentence case, lowercase the entire value first and then capitalize the first character with UCase(Left(value, 1)) & LCase(Mid(value, 2)).
Can I run this sentence-case conversion from an Access update query?
Yes. Create a public VBA function in a standard module, then call it from the Update To row of an update query, for example SentenceCase([FieldName]).
Where should I put the AfterUpdate event code in Access?
Put the code in the form module for the specific control. Open the form in Design View, select the text box, open the Property Sheet, click the Event tab, and choose Code Builder for the After Update event.
Will sentence-case conversion preserve abbreviations and proper nouns?
Not automatically. It may change "NASA" to "Nasa" or alter names. Review the affected records first and add logic or manual corrections for exceptions before storing the final value.
Can WPS Office run Microsoft Access VBA macros?
No. WPS Office does not include an Access database application, so use Microsoft Access for this Access VBA routine and consider WPS Office for Word, Excel, and PowerPoint-compatible work.




