Format case of field

[RRitz]

Microsoft Word has a function to change the case of a field to capitalize the first letter of the word ... for example: JONES to Jones. Is there any thing in ACCESS that will do that function? I can only find upper case or lower case functions.

 

[jebry]

Hi!

The function is called ProperCase.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[Remou]

Hi
You cab use StrConv:
StrConv("JONES", vbProperCase)

By the way, there was quite a long debate in the Access Forms forum on proper case fairly recently, if you are interested.

 

[RRitz]

Appreciate the knowledge you bring to this forum. Microsoft help didn't list this anywhere! I would be interested to read the debate on proper case. I'll do a search in that forum

Thanks.

 

[RRitz]

I do not do much in Access and find it cumbersome at times. I have a query and all I want to do is change a field called "LastName" to propercase. In the expressions builder on the query I have typed in: Expr 1: StrConv(LastName, vbProperCase) ... but just get error messages!! Please help as I have some 6000 letters to go out with this salutation.

 

[RRitz]

Never mind I figured it out. Instead of vbProperCase, I just used the value '3', and it seems to work.

 

[Remou]

Hi
Here is the thread707-1017806 I was muttering about.