changing first letter to uppercase (1 Viewer)

[Patrick Kaldawy]

i need to change the first leeter of every name or other to uppercase is there any way to do that
thank you alot
i salut all access programers

 

[KevinM]

Use the StrConv function.

If you want to update existing records then create an extra column and use the following expression....

NewName:StrConv([FieldName],3)

You can then copy and paste this column over the original column or run an update query.

For ongoing records use the StrConv in the AfterUpdate event of the field in a form

HTH