Proper Format for Text in a Table

[Channah]

I have a table from our billing system and the Cust. name is nasty. I need to Proper format the text for capitalization. Is there a query that can do this for me?

eg... TEK TIPS FORUM should= Tek Tips Forum

Any help would be appreciated.

Thanks,
Chris

 

[Quehay]

Look up the StrConv function in the Visual Basic Help. If you use the vbProperCase constant in lieu of the one in the example you'll capitalize the first letter of each word (but this doesn't give you the logic for proper capitalization of titles, etc.):

[tt]
x = StrConv("ABCDEFG", vbFromUnicode) ' Convert string.
[/tt]


Jeffrey R. Roberts
Insight Data Consulting
Access, SQL Server, & Oracle Development

http://www.insightdataconsulting.com