[b]Convert Only first letter of text in capital in fields[/b]

[yog2go]

Suppose I have a table with fields:

First Last
STEVEN MAKI
JAMES FURNISH
MONICA GARCIA

I need to keep only first letter of each name in capital, rest not in capital. i.e.
Steve Maki
James Furnish
Monica Garcia

Is there any way you can directly format this fields in design view of table using Format property. Or you only can do using VBA Code?
Can you suggest how to do this?

Thanks in advance.

 

[PHV]

In VBA you may use the StrConv function with vbProperCase as conversion parameter.

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