Access 2003 Proper Casing

I

Ian Brooks

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
 
I

Ian Brooks

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.
 
Top