Visual Basic Crystal Reports - How to formate text in Tital Case ?

Author

How to formate text in Tital Case ?

Jayesh Mendpara

2006-03-29, 7:06 pm

I am using crystal report 8.5 and I would like to formate my FullName
field in to Tital Case ...

For Example:
In my database I have Fullname in uppercase like JAYESH D MENDPARA

but on report I would like to display it as : Jayesh D Mendpara

so How can I ?

Thank you very much

-Jayesh

Luqman

2006-03-30, 4:04 am

Download u2lcaps.dll from Crystal report web site, and copy this to your
system32 directory.

Now Start Crystal Report 8.5, you will see LeadingCaps Function in
Additional functions.

You can use this function as under:-

LeadingCaps("LUQMAN")
will return Luqman

If you can't find that file, E-Mail me directly at luqman@pearlsoft.com.pk
and I will send it to you.

Best Regards,

Luqman

"Jayesh Mendpara" <jmendpara@gmail.com> wrote in message
news:1143658146.996950.322890@g10g2000cwb.googlegroups.com...
>I am using crystal report 8.5 and I would like to formate my FullName
> field in to Tital Case ...
>
> For Example:
> In my database I have Fullname in uppercase like JAYESH D MENDPARA
>
> but on report I would like to display it as : Jayesh D Mendpara
>
> so How can I ?
>
> Thank you very much
>
> -Jayesh
>

Sponsored Links