Blank line suppress in Word Automation

[Stan Denman]

I have code that merges access xp data into word
templates by setting the values of Word document custom
properties. The word templates have fields referencing
the name of the custom properties For address info in
the access db I have two possible field for address.
Typically both have records for say people in an
apartment, but for home address typically one, the second
field, is null. When the custom properties are set
through automation, however, a blank is left where that
custom property is referenced.

Any ideas? Thanks.

 

[doj]

Need more info
Are you using fields in the word doc or a macro to insert the
information
if fields then look at examples of if fields in the word help
if macro then test for existance of data by using len
hope this helps