Adib,
Look up the use of the StrConv function.
StrConv(string, conversion, LCID)
using 3 as the conversion (vbProperCase) should do what you want. For example, in a query, you
can use:
ProperCase: StrConv([FieldName], 3)
where [FieldName] is the name of your text field.
Tom
_________________________________
news:
[email protected]...