StrConv("this is a test", 3)
 
will return:
This Is A Test
 
 

Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
734.264.0911 (F)


 
 


From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of bitschon
Sent: Thursday, December 15, 2005 3:15 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Capitalized the Initial Letter in words in String

I am loading a list box with short strings of words. The Case of the
words is rather random.  I want to show them with the initial letter of
each word in the string capitalized and the rest of the letters not

Is there a function that will do this quickly?  I also do not want the
user to have to wait too long.  I got this to work with Split...but it
is way too slow.

Informix has an initcap function...too bad I can't put native functions
in the query






Please zip all files prior to uploading to Files section.




YAHOO! GROUPS LINKS




Reply via email to