Initial capitalization

[Ruchi]

Hi,
Can someone please help as to how to dsiplay data in a
report like name in its initial capitalization format.

In sql we had function INITCAP..
is there any such facility available or any code we can
write to gain this facility.

Regards,

Ruchi

 

[Jeff Boyce]

Ruchi

Check Access HELP on "Proper Case" and the StrConv() function for syntax.

Good luck

Jeff Boyce
<Access MVP>

 

[Ruchi]

Jeff,
Kindly help me further with this... i tried using this
but couldn't understand proper way of get out desired
result.

 

[Guest]

Thanks a lot Jeff.. i got the conversion factor...

Thanks a lot really.............

 

[Ruchi]

Really Thanks a lot Jeff