Automatic conversion to Upper Case

[Jon]

Anyone know how to program reports to print out some fields, eg name fields,
that will automatically correct lower case characters to upper case,
especially for the first letter?
E.g.: john smith --> John Smith or m --> M

Thanks in advance.

 

[Fredg]

Jon,
Do you want UPPER CASE or Upper Case?

1) [ControlName] = UCase([ControlName])
or..
2) [ControlName] = strConv([ControlName],3)

Some names do not get properly converted because they have more than one
capital letter in it, i.e. McDonald - Mcdonald, ABC - Abc, etc.