Access 2003 Proper Casing

[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

 

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