Changing UPPER to Proper Case

[FmEdit]

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

 

[PieterLinden via AccessMonster.com]

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 <space><backslash><space> then do the
conversion with StrConv and then run the replace again to make
<space><backslash><space> back into <backslash>.

Isn't Access FUN?

 

[Douglas J. Steele]

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 <space><backslash><space> then do the
conversion with StrConv and then run the replace again to make
<space><backslash><space> back into <backslash>.

In other words,

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