[Larry S.]

I am using Access 2002 to set up a mail merge letter and envelope. Some of
the records in my Access database don't have all of the name and address
fields. In older versions of Access that I used in the past, I was able to
use an "IF" field to to essentially say that if the field existed to add a
space after it, otherwise don't add the space. i.e. one record has a
"middlename" field, another doesn't. I don't want the one without the
middlename field to have two spaces between first and last name, which would
happen if I hard coded the spaces in. Same thing if a record doesn't have a
salutation field, or perhaps a title field.

How can I use if messages and/or switches to best set this up? Can it be
done both ways? If so, I would appreciate getting info on both, and the
reasons to prefer one or the other. Thanks.



--
Larry S