format merged data from access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hughess7 - 29 Nov 2005 16:37 GMT

Hi all

I have a merged letter which is created from within MS Access, it merges two
company names per page and I want both of these to be all capitalised. I
looked in help and found an article on formatting merged data. It stated I
could put the switch \*Upper to achieve the result I want. I pressed Alt F9
to view the merged code and added the switch but it does not work.

Help did not actually show an example, I've tried adding it to the front and
behind the field name eg « MERGEFIELD "MergeName" \*Upper » or « MERGEFIELD
\*Upper "MergeName" » and also inside the quotes but nothing seems to work?

Can anyone help with this please?

Thanks in advance.
Sue

Reply to this Message

hughess7 - 29 Nov 2005 16:42 GMT

sorry... I had spaces in the switch which it didn't like. Removed these and
now all names are displayed in capitals as desired.

Thanks
Sue

> Hi all
>
[quoted text clipped - 12 lines]
> Thanks in advance.
> Sue

Reply to this Message

Graham Mayor - 29 Nov 2005 16:46 GMT

If you have an inseted field called <<Mergename>> and you toggle the field
with ALT+F9, you should see
{Mergefield Mergename} It is with this view that you should add switches
thus

{Mergefield mergename \*Upper}

See also http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi all
>
[quoted text clipped - 14 lines]
> Thanks in advance.
> Sue

Reply to this Message