Help with reformatting field text

[danboi10]

Hello,

I'm currently working on automated letter and as a general rule it is going well, to the point where with a click of a button all fields and text are sent to the word document. The problem that is causing me the biggest headache is when i try to reformat the caps entry into proper text.

For reason beyond me it has been decided that the access database entry must be in CAPS but this looks unprofessional in a letter, so I'm trying to reformat to proper text. Below is part of the code that I have been using. NAME is the the field (First & Surname).

WrdApp.Selection.TypeText Text:=(NAME)
WrdApp.Selection.Range.Case = wdLowerCase

But all this code does is change the last name to lowercase.

I have been searching the internet all day and still cannot come up with an answer .......

Any help would be appreciated.

Dan.

 

[vbaInet]

Create a query and change the caps in the field using the StrConv() function.

 

[danboi10]

Just back from leave. Thanks.Dan.

 

[vbaInet]

You're welcome.