Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: lose formating when i merge

    I have a form that merges it's data with a word document. I have to convert a number from a table into a word. I have do that by using =IIf([Type]=986,"Monkey",[Type]). When I merge this result, the word document shows 986. Is there anyway to format the merge to show monkey?


    Thanks.

  2. #2
    Join Date
    Mar 2004
    Posts
    33
    You will need to do this from within the Microsoft Word main document itself or change the merge query to include a calculated field.

    It will be simpler from Microsoft Word since it also supports the IIF function.

    I haven't used the IIF statement in a while but what happens if you try this:

    IIf([Type]=986, [Type]="Monkey").
    Last edited by toliver; 03-20-04 at 05:06.

  3. #3
    Join Date
    Mar 2004
    Posts
    361
    I get a name error. I just have a feeling that I need to do the formating in word and not in access.

  4. #4
    Join Date
    Mar 2004
    Posts
    361
    Do you think it would help if I used the REF formating in word?

Posting Permissions

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