access report proper case

[john_h_kraft_1941]

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

[#2]

@john_h_kraft_1941 

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.