Access 2003 Proper Casing

#1 (**permalink**) 26-Oct-2005, 17:53 PM

Using STRCONV function in Access 2003 to convert text data has the following
effect
on hyphenated words:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/5830-access-2003-proper-casing.html

SMITH-JONES converts to Smith-jones

However using the Word 2003 case converter will convert this string to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5830
Smith-Jones. How can I get the same functionality ie the next letter after
the hyphen is upper cased, into Access 2003?

Thanks

*

#2 (**permalink**) 27-Oct-2005, 08:58 AM

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

strconv(left("JONS-SMITH",instr("JONS-SMITH","-")-1),vbProperCase) & "-" &
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5830
strconv(Mid("JONS-SMITH",instr("JONS-SMITH","-")+1),vbProperCase)
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

"Ian Brooks" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5830
> Smith-Jones. How can I get the same functionality ie the next letter after
> the hyphen is upper cased, into Access 2003?
>
> Thanks

#3 (**permalink**) 27-Oct-2005, 08:58 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5830

"Ofer" wrote:

> You'll need to break the name into two, and then use the STRCONV
>
> strconv(left("JONS-SMITH",instr("JONS-SMITH","-")-1),vbProperCase) & "-" &
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5830
> strconv(Mid("JONS-SMITH",instr("JONS-SMITH","-")+1),vbProperCase)
> --
> If I answered your question, please mark it as an answer. That way, it will
> stay saved for a longer time, so other can benifit from it.
>
> Good luck
>
>
>
> "Ian Brooks" wrote:
>
> > 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