Forum Discussion
access report proper case
in access report how to display a text field to proper case
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.