I use word 2000 and access 2000. In access, I create all caps by using in
the format section of my table. When I merge labels in word using the mail
merge feature, with access data as the source, the labels come out lower or
initial case.

Q. The result I want is for fields [firstlast], [address], and [city state]
when I print in word via mail merge to come out as all caps.

I am not familiar with vba, basic or other programming language.
Guidance would be greatly appreciated.

Use Alt+F9 to toggle on the display of the field codes and add the \*
Charformat switch to the mergefields and format the m of Mailmerge (using
FormatFont) to be All Capitals.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"harvey" wrote in message
...
I use word 2000 and access 2000. In access, I create all caps by using
in
the format section of my table. When I merge labels in word using the
mail
merge feature, with access data as the source, the labels come out lower
or
initial case.

Q. The result I want is for fields [firstlast], [address], and [city
state]
when I print in word via mail merge to come out as all caps.

I am not familiar with vba, basic or other programming language.
Guidance would be greatly appreciated.