Upper to Mixed Case

[mdr227]

Can someone tell me how to convert a field of text that is all upper case to mixed case (first letter of each word capitalized)?

 

[PHV]

Take a look at the StrConv function with 2nd argument = vbProperCase

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[CharlieT302]

There is an easy fix that can be done directly from table design.

In the "Input Mask" property type the following code:
>a<aaaaaaaaaaaa

Where the total number of "a" codes must match the value indicated in the "Field Size" property.

 

[Golom]

PHV

You're right of course ... but I've found that StrConv has a bug in it.

StrConv ("convert to proper case", vbProperCase )

blows up but

StrConv ("convert to proper case", 3 )

works even though vbProperCase = 3.

 

[PHV]

Golom, I guess your StrConv call was issued in a query and thus no VB constant is recognized.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244