Blank line suppress in Word Automation

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
Wed Jul 02 17:36:06 CDT 2003

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

On Wed, 2 Jul 2003 14:59:42 -0700, "Stan Denman"
<standenman@hotmail.com> wrote:

>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.