RE: [AccessDevelopers] Capitalized the Initial Letter in words in String

[Tom Oakes]

You probably want to wrap this in a function, and you may 
need to modify your "placeholder" for the slash, but: 
 
?Replace(StrConv(Replace("this/is/a/test", "/", " / "), 3), 
" / ", "/")
 

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 john 
sayreSent: Thursday, December 15, 2005 4:22 PMTo: 
AccessDevelopers@yahoogroups.comSubject: RE: [AccessDevelopers] 
Capitalized the Initial Letter in words in String

Is there any way I can define the backslash and forward slash 
as word separaters?Tom Oakes <[EMAIL PROTECTED]> 
wrote: 

  
  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 
  bitschonSent: Thursday, December 15, 2005 3:15 PMTo: 
  AccessDevelopers@yahoogroups.comSubject: [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 
  notIs 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



   Visit your group "AccessDevelopers" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.