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.