string expressions with null values

[Stacey]

How do I string these together?
=IIf(IsNull([ParentsFirstNameDad]),[ParentsFirstNameMom],[ParentsFirstNameMom] & " & " & [ParentsFirstNameDad])

and

=IIf(IsNull([HomeAddress]),"",[HomeAddress] & ", " & [Zip])

 

[Douglas J. Steele]

String together how?

Actually, for your first one, you can take advantage of the fact that + and
& have different behaviours when dealing with Nulls. Null + something
results in Null, while Null & something results in something. That means you
can use

ParentsFirstNameMom] & (" & " + [ParentsFirstNameDad]))

How do you want to string them together after that? Do you want the home
address to be on a separate line?

ParentsFirstNameMom] & (" & " + [ParentsFirstNameDad])) & (vbCrLf +
[HomeAddress] + ", " + [Zip])

 

[Stacey]

very cool!

String together how?

Actually, for your first one, you can take advantage of the fact that + and
& have different behaviours when dealing with Nulls. Null + something
results in Null, while Null & something results in something. That means you
can use

ParentsFirstNameMom] & (" & " + [ParentsFirstNameDad]))

How do you want to string them together after that? Do you want the home
address to be on a separate line?

ParentsFirstNameMom] & (" & " + [ParentsFirstNameDad])) & (vbCrLf +
[HomeAddress] + ", " + [Zip])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

How do I string these together?
=IIf(IsNull([ParentsFirstNameDad]),[ParentsFirstNameMom],[ParentsFirstNameMom]
& " & " & [ParentsFirstNameDad])

and

=IIf(IsNull([HomeAddress]),"",[HomeAddress] & ", " & [Zip])