Upper Case

[DeutchBose]

How do I make 'john smith' into 'John Smith'?

 

[Norie]

Try:

StrConv([NameField], vbProperCase)

This works in Access 2000 - I don't know about earlier versions.

 

[DeutchBose]

I'm using XP and it doesn't seem to work...I'm using it within an Access Report...I tried putting single and double quotes around vbProperCase, but it doesn't take either way...

 

[Norie]

I'm using XP and it doesn't seem to work

How?

I tried putting single and double quotes around vbProperCase

You don't need quotes it's a VB constant.

Is the report based on a query?

If it is why not use whay I posted in the query?

eg ProperName:StrConv([NameField], vbProperCase)

BTW remember to change the field names.

 

[DeutchBose]

It does not work in a query or in a report. It did not work without quotes or with quotes, and if I do not put quotes around vbProperCase, Access automatically puts brackets [] around it. This is the field I've put in my query:

EName: StrConv([ch_EngineerName], vbProperCase)

It comes back with brackets[] around vbProperCase and asks for a value for vbProperCase.

I notice that 'StrConv' only shows up in the Help section of the VBA Editor, but not generally in Access...perhaps I'm missing something else?

 

[Norie]

perhaps I'm missing something else?

It's probably me that's missing something.

Try replacing vbProperCase to 3, that's it's actual value.

And check this How to use the StrConv function to capitalize words and phrases in Access 2002