Macro to change text case

[OzBushDude]

Hi:

I use an Access table for data entry, much of which is pasted in the table
from other sources. Many times, the text pasted is ALL UPPERCASE TEXT, which
drives me nuts, as I have to go in and manually change it to All Title Case
Text.
I have tried to put together a macro that will let me select the text and
have the macro change it to Title Case (similar to what you can do in Word,
using the Format command).
I'm having no luck with this - anyone have any suggestions? This is such a
simple task, yet I cant find any commands in Access that will work.

Thx!

 

[Nikos Yannacopoulos]

What you need is an Update query on the table, not a macro! In the query
design, you need to use the built-in function StrConv (look it up in
help) in the Update To box under the table field(s) in the grid; so, for
Field1, for instance, the syntax would be:
StrConv([Field1],3)

Caution: back-up before you try anything you're not 100% sure about!

HTH,
Nikos