From Access Help:
About combining text values from fields when some fields contain no data
When you combine text values from several fields, some records might contain
empty fields, resulting in output that might not be what you want. For
example, the output might include extra spaces.
To compensate for records that don't have values in certain fields, you can
use the IIf function. You use the IIf function when you want the value (or
absence of a value) in one field to determine which one of two possible
results you want returned.
For example, if you know that not every record will have a value in the
Region field, use the following expression:
=[Address] & ", " & [City] & IIf(IsNull([Region]),"", " " & [Region]) & " "
& [PostalCode]
If the Region field is empty, Microsoft Access returns no value, as
specified by the argument "". If the Region field contains a value,
Microsoft Access returns a space and the region, as specified by the
argument " " & [Region].
HTH
Mich
