Is there a way to get Text Box in proper case on a report?

[DIRENE]

I have a report named rptLetter on the report I pull customer information from a query. Every thing in my database is typed in caps. Is there a way to get them to pull in my report like Irene not IRENE.

Thank you,

Irene

 

[mgolla]

On the Detail_Format add this:

TextField = StrConv(TextField, vbProperCase)

HTH
Mike

 

[DIRENE]

Mike,

I put this in detail on formating and I'm getting a error message that micosoft access can't find the macro "TextField = StrConv(TextField, vbProperCase)

Irene

 

[mgolla]

Change "TextField" to the name of your text field

HTH
Mike

 

[DIRENE]

Mike, I change the textfield to Firstname and it still does not work

Irene

 

[DIRENE]

Do I have to have a marco or module of some kind?