Capitalize first letters

[Razor]

Hi,

Access newbie here, got a problem I'm sure is pretty easy to solve but I
don't have an access manual and can't find the solution in the help file.
I've recently switched from Lotus Approach 96 to Access 2000, and under
Approach I could design forms in which the first letter of each word in
certain fields was capitalized automatically. For example, if a field was
called "city" and I wanted the "L" and "V" in Las Vegas to capitalize
automatically without user intervention it would happen. I can't find a way
to do this in Access. Any help would be appreciated.

Mike

 

[Luiz Cláudio C. V. Rocha [MVP]]

StrConv("your text", 3)

Luiz Cláudio C. V. Rocha
São Paulo - Brazil

 

[Razor]

Thanks, where should I type the formula?

StrConv("your text", 3)

Luiz Cláudio C. V. Rocha
São Paulo - Brazil

 

[jwm]

Assuming you want the words capitalized when entered on a form...check
http://www.csvtools.com/

There's a free tool for initial caps and a multi-cap version included in the
CSV Tools collection.

 

[Razor]

Thanks for the suggestions, but I have to say I'm amazed that something that
should be so simple requires additional software or a formula to accomplish.
Is there really no easy method built into Access? Lotus Approach had it in
the 96 version.

 

[Luiz Cláudio C. V. Rocha [MVP]]

You can use it on yopur textbox AfterUpdate event (create an event
procedure).

Luiz Cláudio C. V. Rocha
São Paulo - Brazil