access report proper case

Occasional Visitor

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

1 Reply

@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.