debobrien
asked on
Logic to suppress text if a bookmark is null in Word 2007 template
I have a word 2007 template and on it I print a bookmark field called Line custom form field 4 which is a contract number. I have included text “Contract #:” which precedes the bookmark.
i.e.: (Contract #: bookmark)
The problem is there is not always a contract number but the text “Contract #:” still prints out with nothing to the right of it.
Is there a way to suppress the text if the bookmark is null?
I tried an if statement that I found online (microsofts website) but all it did was print out my entire statement as text.
{If {Line custom form field 4} = “” “” “Contract# :”}
I’m sure the syntax is wrong but can’t seem to find anything on how to do this.
i.e.: (Contract #: bookmark)
The problem is there is not always a contract number but the text “Contract #:” still prints out with nothing to the right of it.
Is there a way to suppress the text if the bookmark is null?
I tried an if statement that I found online (microsofts website) but all it did was print out my entire statement as text.
{If {Line custom form field 4} = “” “” “Contract# :”}
I’m sure the syntax is wrong but can’t seem to find anything on how to do this.
In the code that creates a new document from the template, look at the Contract # value, and if it is Null or empty, delete that line from the document.
ASKER
Where is that code? These templates are created through an ERP software package's document printing function. When I create a document, I just tell it I want to use Word options and it creates a blank template and provides the bookmarks for all the available db fields I can use on the template. (See attached).
I was hoping I could code something right on or within the template like I can with an Access form.
I was hoping I could code something right on or within the template like I can with an Access form.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
A usable solution was not offered here.