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

    Unanswered: Hide values in word merge

    I have a form that merges info into word with a click of a buttton. I want to sum and few text boxes but they all have to have some type of value to complete the sum. It must have at least a 0 to perform the calculation. The problem is when I merge, I don't want any 0's to show up. Is there a way to hide a value if it is null in a word merge. Thanks for the help.

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    <<
    ...but they all have to have some type of value to complete the sum...
    >>

    Well in Access you could do this with the function that converts Null to zero:
    =NZ(MyControl1) + NZ(MyControl2)

    Or if the Word mailmerge doc were based on the underlying query, you could have some extra calculated fields in the query that are exactly how you want them for Word.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Mar 2004
    Posts
    361
    wouldn't I need to convert a 0 to null?

Posting Permissions

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