Hello All,
I have a table that has title, first name and last name attributes.
Normally the title is “Mr. and Mrs.” or “Ms.” but sometimes there are no values entered.
When I merge data (using a query) into Word 2000 the results are less than satisfying.
<Title> <First Name> <Last Name>
Example of results:
Mr. and Mrs. Joe Smith
_Jane Doe (_ indicates a blank space)
Ms. Sally Jones
Jane Doe is indented by one space. Since there was no value in the Title field, WORD 2000 still prints the space I set between <Title> <First Name>
I tried to build in a trailing space into a new merge field called <WordTitle>
If I do a query in Access 2000, then the trailing space appears to be included.
The modified merged data appears as follows:
<WordTitle><First Name> <Last Name>
Example of the results:
Mr. and Mrs.Joe Smith
Jane Doe
Ms.Sally Jones
The trailing space was not part of the merge.
Any ideas on how I can solve this problem?
Divit11
I have a table that has title, first name and last name attributes.
Normally the title is “Mr. and Mrs.” or “Ms.” but sometimes there are no values entered.
When I merge data (using a query) into Word 2000 the results are less than satisfying.
<Title> <First Name> <Last Name>
Example of results:
Mr. and Mrs. Joe Smith
_Jane Doe (_ indicates a blank space)
Ms. Sally Jones
Jane Doe is indented by one space. Since there was no value in the Title field, WORD 2000 still prints the space I set between <Title> <First Name>
I tried to build in a trailing space into a new merge field called <WordTitle>
If I do a query in Access 2000, then the trailing space appears to be included.
The modified merged data appears as follows:
<WordTitle><First Name> <Last Name>
Example of the results:
Mr. and Mrs.Joe Smith
Jane Doe
Ms.Sally Jones
The trailing space was not part of the merge.
Any ideas on how I can solve this problem?
Divit11