Automatic conversion to Upper Case

  • Thread starter Thread starter Jon
  • Start date Start date
J

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.
 
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.
 
Back
Top