Text manipulation

[Keith]

Is there any way to replicate the 'Proper' worksheet function in Access?

Thanks
Keith


[This message has been edited by Keith (edited 06-03-2000).]

 

[R. Hicks]

This will convert the first letter of each word to capitals.

StrConv([yourField],vbProperCase)

HTH
RDH

 

[Pat Hartman]

If you use this function in a query, you need to use the vb constant value rather than its name.

StrConv([yourField],3)