Automation removing blanks in Word

J

JJP

I've written code to send the current record from an access form to a Word
2000 document (following, more or less, the microsoft support document
210271). However, if the field in the form is blank, although the error trap
replaces the blank with "", it still leaves a blank line in the word
document. This is mainly a problem with addresses. For example, if their are
4 fields for the various bits of an address, but only 3 are used, the word
document looks like:

1, Acacia Avenue,

London,
1AA 2BB.

Is there any code I can use to get rid of this problem?
Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top