Format Names

  • Thread starter Thread starter Chris
  • Start date Start date
C

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.
 
Chris said:
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.
Click to expand...

FormattedName: StrConv([NameField], 3)

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