Proper() is the function.
Proper(FamilyName) will make the first letter of each word a capital and the rest lowercase
if you only want the first letter a capital, then use:
upper(left(familyname; 1 )) & lower(middle(familyname ; 2 ; 100))
Hope that helps
Dear user19752 and Ruben,
Thank you to both of you! Likely easy for you, still tough for me at this stage. I went through the text functions, searching for left, right, trim, omit etc. but no bells rang when I passed middle upper and lower. I promise I'll look even more thorrough next time.