Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word format (2000)

    I have a field, which will be used for a mail merge letter. How do I make sure that the first letter is in caps.

    ContactName

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word format (2000)

    I would create the merge linking to a query. For your query, I would make a field as such:

    ContactName: StrConv([ContactName],3)

    If you wish to keep your data in whichever case it is in your table. If you want to fix the problem from the get-go, use an update query:

    Field: ContactName
    Update To: StrConv([ContactName],3)

    You can change the number to change the case

    1- ALL CAPS
    2- all lower case
    3- Proper Case
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Word format (2000)

    Jeremy's suggestion should do the trick, but it is also possible to set the format in Word:
    - Right-click the merge field in Word and select Toggle Field Codes from the popup menu.
    - The field will look like this:

    { MERGEFIELD Fieldname * MERGEFORMAT }

    - Edit it to look like this:

    { MERGEFIELD Fieldname * FirstCap * MERGEFORMAT }

    - Press F9 to hide field codes and update the field.

  4. #4
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word format (2000)

    Hans,
    Thanks for that tip! I didn't know you could format the fields in word - I've always done it in the Access or Excel word document!
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Word format (2000)

    It can be very useful. Sometimes you cannot do anything about the format in the data source, for example because it is read-only.

  6. #6
    Star Lounger
    Join Date
    Oct 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word format (2000)

    Big help - thanks!

  7. #7
    Star Lounger
    Join Date
    Oct 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word format (2000)

    This works great! Thank you very much.

Posting Permissions

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