How Do I Get a field in a form to convert to Proper Case? 2

[SALEEYOUNG]

On my form I would like my fields to display in Proper Case format. I am using Access 2000 and on the help menu there is a worksheet function called Proper (setup: Proper(text)). However, I have no idea how or where to use this function!!I'm still a novice at this!!! Is there anyway I can make several fields display Proper case without having to write code over again for each field (which I also do not know how to write!). Any help in this area would be greatly appreciated. Thank you. Sandra

 

[SJMcAbney]

Use the StrConv() function.

In a query, or a form control:

=StrConv([MyField],3)

The same is allowed in VBA but you can also use the enumerated constant vbProperCase.

=StrConv([MyField], vbProperCase)



Stewart J. McAbney | Talk History