Access 2003 Proper Casing

[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

 

[Guest]

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)

 

[Guest]

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.