Results 1 to 2 of 2
  1. #1
    LeesKeys is offline Novice
    Windows XP Access 2000
    Join Date
    Oct 2011
    Posts
    5

    merging check box information into Word Docs


    Some of the information that I'm merging into a Word document is based on Yes/No fields. These fields appear as check boxes on Access forms, but when I merge the data into MS Word, the results end up as -1 or 0. What do I need to do so that the results, when merged into my Word Doc, are "Yes" or "No" rather than -1 or 0? I'm using Access 2000.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,600
    Try creating an alias field with an expression then use that field in the merge.

    Data1: IIf([fieldname]=-1,"Yes", "No")
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Merging information to create ID field.
    By Raga32 in forum Forms
    Replies: 3
    Last Post: 08-08-2011, 03:09 PM
  2. Generate docs from MS access
    By matspring in forum Access
    Replies: 2
    Last Post: 05-07-2011, 07:48 PM
  3. Replies: 1
    Last Post: 07-27-2010, 07:06 AM
  4. Creating Links to Word Docs
    By kingharvest in forum Access
    Replies: 1
    Last Post: 05-19-2010, 10:28 PM
  5. word docs.
    By laqsb in forum Access
    Replies: 1
    Last Post: 02-26-2010, 08:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums