remove & if no data

[angie]

I use the following as a default value in a text box


If there is no “spouse” name I would like the & to notshow.
The way it is now it would show “ first name & last name


=[Forms]![Customer]![FirstName] & " & "& [Forms]![Customer]![Spouse] & " " &[Forms]![Customer]![LastName]

[pbaldy]

If the field is Null:

=[Forms]![Customer]![FirstName] & (" & " + [Forms]![Customer]![Spouse]) & " " &[Forms]![Customer]![LastName]

which takes advantage of the fact that + propagates Nulls.

[isladogs]

There are several ways of solving this including
1. Using If...Else... End If where the if condition is Nz(Spouse,"")<>""

2. Replacing the Spouse part with an Nz statement

3. Using + instead of & to concatenate the & Spouse part

[firstName] & " & " + [Spouse] & " " & [LastName]

Method 3 is probably simplest

EDIT: Paul got there first

[angie]

Thank you, that worked just how I needed it to.....