Changing UPPER to Proper Case

Hi,

Using Office 2007 with SP2

In a query I use the function: Strconv([Customer],3) for converting
upper to proper case

Only snag is:

RED LION 49/SOLID STATE LOGIC comes out as Red Lion 49/solid State
Logic

Anything with a / or - before the word is not converted to proper case

Any ideas ?

In Excel using the Application.Proper function gives me exactly what I
need but would prefer this to be done in Access

TIA

Raymond

FmEdit wrote:
Hi,

Using Office 2007 with SP2

In a query I use the function: Strconv([Customer],3) for converting
upper to proper case

Only snag is:

RED LION 49/SOLID STATE LOGIC comes out as Red Lion 49/solid State
Logic

Anything with a / or - before the word is not converted to proper case

Any ideas ?

In Excel using the Application.Proper function gives me exactly what I
need but would prefer this to be done in Access

TIA

Raymond

Convert the "/" to something like spacebackslashspace then do the
conversion with StrConv and then run the replace again to make
spacebackslashspace back into backslash.

Isn't Access FUN?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200907/1

"PieterLinden via AccessMonster.com" u49887@uwe wrote in message
news:98e7f8e681f94@uwe...
FmEdit wrote:
Hi,

Using Office 2007 with SP2

In a query I use the function: Strconv([Customer],3) for converting
upper to proper case

Only snag is:

RED LION 49/SOLID STATE LOGIC comes out as Red Lion 49/solid State
Logic

Anything with a / or - before the word is not converted to proper case


Convert the "/" to something like spacebackslashspace then do the
conversion with StrConv and then run the replace again to make
spacebackslashspace back into backslash.

In other words,

Replace(Replace(UCase(Replace(Replace([Customer], "/", " / "), "-", " - "),
3), " / ", "/"), " - ", "-")


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)