Changing UPPER to Proper Case

  • Thread starter Thread starter FmEdit
  • Start date Start date
F

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 said:
FmEdit said:
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
Click to expand...

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>.
Click to expand...

In other words,

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