Conditional New line

Posted on 2011-05-04
Medium Priority
Last Modified: 2012-05-11
I want to create a document with docvariables that I will substitue from a MS Access database. One of them is Address2 which I want to put on a new line if it is not blank but if it is blank then I don't want to include it. How do I do that? e.g. in the example below I don't want to use address2
Question by:Rob4077

Accepted Solution

lwebber earned 2000 total points
ID: 35706503
One way to do this would be to include the Paragraph mark (or Newline character) in the data you stuff in from Access. You would then put all the DOCVARIABLEs one after another, and let the supplied data cause the elements to be on separate lines.

Author Comment

ID: 35710500
Thanks lwebber, that sounds like ti would work and since no other suggestions have come in I will assume it is the best solution. Appreciate your suggestion.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Suggested Courses

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question