Access 2003 Proper Casing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using STRCONV function in Access 2003 to convert text data has the following
effect
on hyphenated words:

SMITH-JONES converts to Smith-jones

However using the Word 2003 case converter will convert this string to
Smith-Jones. How can I get the same functionality ie the next letter after
the hyphen is upper cased, into Access 2003?

Thanks
 
You'll need to break the name into two, and then use the STRCONV

strconv(left("JONS-SMITH",instr("JONS-SMITH","-")-1),vbProperCase) & "-" &
strconv(Mid("JONS-SMITH",instr("JONS-SMITH","-")+1),vbProperCase)
 
Thanks for that Ofer, much appreciated. I just find it incredble that these
functions work differently in different areas of an integrated package.

Again, thanks.
 
Back
Top