Format Names

[Chris]

Hi,

How can I have my names formatted as such:
Jane Smith, regardless of the number of character
involved? At the moment I have all letters in uppercase
like this: JANE SMITH. But is is not always very good
looking especially when creating labels and letter headers.

Thanks in advance,
Chris.

 

[Rick Brandt]

Hi,

How can I have my names formatted as such:
Jane Smith, regardless of the number of character
involved? At the moment I have all letters in uppercase
like this: JANE SMITH. But is is not always very good
looking especially when creating labels and letter headers.

FormattedName: StrConv([NameField], 3)

This will be imperfect if you have names like vanGelder or MacDonald, etc..