How do you keep Word from putting an extra space between fields that are on
the same line when there is a field that may be blank for some records - a
middle initial field, for example. Some records will have middle initials
resulting in correct spacing between the various fields, but when the middle
initial field is empty the spacing between the first and last name will be
wrong. Thank you for your help.

You use an IF field to test for any contents in the may-be-blank field. If
the field is not blank, insert the field and a space, if it is blank, insert
nothing.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"Harry Weeds" wrote in message
...
How do you keep Word from putting an extra space between fields that are
on
the same line when there is a field that may be blank for some records - a
middle initial field, for example. Some records will have middle initials
resulting in correct spacing between the various fields, but when the
middle
initial field is empty the spacing between the first and last name will be
wrong. Thank you for your help.

{Mergefield First_Name}{IF {Mergefield Initial} "" " {Mergefield
Initial}"} {Mergefield Last_Name}

Note the space at
" {Mergefield Initial}"}
and before
{Mergefield Last_Name}
No space after
{Mergefield First_Name}
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Harry Weeds wrote:
How do you keep Word from putting an extra space between fields that
are on the same line when there is a field that may be blank for some
records - a middle initial field, for example. Some records will
have middle initials resulting in correct spacing between the various
fields, but when the middle initial field is empty the spacing
between the first and last name will be wrong. Thank you for your
help.

Harry,
This also works for me:
{ Mergefield First_Name }{ Mergefield Middle_Name \b " " } { Mergefield
Last_Name }

Using the "before" (\b) switch. And using the spacing that Graham has stated
already.

For prefixes such as Mr., Mrs., Ms., I have a column named "Prefix". The line is
set up lile this:

{ Mergefield Prefix \f " " }{ Mergefield First_Name}{Middle_Name \b " " } {
Mergefield Last_Name }

Using the "after" (\f) switch. Also using the spacing that Graham has stated
already.

--
Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Graham Mayor" wrote in message
...
{Mergefield First_Name}{IF {Mergefield Initial} "" " {Mergefield
Initial}"} {Mergefield Last_Name}

Note the space at
" {Mergefield Initial}"}
and before
{Mergefield Last_Name}
No space after
{Mergefield First_Name}
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Harry Weeds wrote:
How do you keep Word from putting an extra space between fields that
are on the same line when there is a field that may be blank for some
records - a middle initial field, for example. Some records will
have middle initials resulting in correct spacing between the various
fields, but when the middle initial field is empty the spacing
between the first and last name will be wrong. Thank you for your
help.