Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am using an Access database where for several of the fields I I have enterred data in lowercase however I have set the fields' format to < (UPPERCASE). When I do a mail merge these fields revert to lowerecase. How do I maintain the fields in UPPERCASE after merge? Thanks!!

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    A few things ...

    Using < or > as a format in Access does NOT change the actual stored text - just how it is displayed in Access.

    So you could base the mail merge on a query that converts the text to Upper Case using the StrConv function.

    So say you had a field called Town in Access that was lowercase. In the query you would do this:

    City: StrConv([Town], vbUpperCase). Then use the field City in the merge.

    This does not change what is actually stored in Access.

    Another option is to run an Update query in Access that actually changes the stored data in Access.
    Regards
    John



  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Quote Originally Posted by bbrown5 View Post
    I am using an Access database where for several of the fields I I have enterred data in lowercase however I have set the fields' format to < (UPPERCASE). When I do a mail merge these fields revert to lowerecase. How do I maintain the fields in UPPERCASE after merge? Thanks!!
    Hi bbrown5,

    The easiest way to fix this is to modify the mergefield(s) in Word. That way, you don't need to make any changes to the database.

    In Word:
    1. Select the problem mergefield (eg «MyField») and press Shift-F9. You should now see {MERGEFIELD MyField}
    2. Edit the field code by adding a formatting switchm, thus: {MERGEFIELD MyField \* Upper}
    3. Press F9 to update the field
    4. Repeat steps 1-3 for each problem mergefield
    5. Run your mailmerge.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for both suggestions. I haven't tried the StrConv function yet however will keep in my trouble shooting folder. Addressing the MERGE fields in Word works beautifully.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •