Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

access report proper case

Copper Contributor

in access report how to display a text field to proper case

1 Reply



You can wrap the text values in an expression:


?Proper("PROPER CASE")
Proper Case


Note, however, that this may not always produce the results you expect.


?Proper(" Charles de Batz-Castelmore d'Artagnan")
Charles De Batz-Castelmore D'Artagnan


You may need to resort to a more sophisticated VBA function if your data is like this.