IIF in label report

[Guest]

In printing labels, I have three phone numbers (Home, Office, & Cell and I am
trying to print a label in front of each one if there are data present. So I
go to my label in design mode and on the line for Phone, I keyed in:
=IIF([Phone] is null, "", "PHONE: " [Phone]). I get an invalid syntax -
operand w/o an operator. It appears to me I can't use the IIF within a
label? I would appreciate any help you may give me. Thanks, Tom

 

[Gina Whipp]

Try: =IIf([Phone] Is Null, "", "PHONE: " & [Phone])

 

[John Vinson]

In printing labels, I have three phone numbers (Home, Office, & Cell and I am
trying to print a label in front of each one if there are data present. So I
go to my label in design mode and on the line for Phone, I keyed in:
=IIF([Phone] is null, "", "PHONE: " [Phone]). I get an invalid syntax -
operand w/o an operator. It appears to me I can't use the IIF within a
label? I would appreciate any help you may give me. Thanks, Tom

A simpler option involves no IIF at all, and uses the fact that both
the & and + operators concatenate strings, but the + operator returns
NULL if either string is NULL:

= "PHONE: " + [Phone]


John W. Vinson[MVP]

 

[Guest]

Perfect!! Thanks to both of you for solving my problem.

In printing labels, I have three phone numbers (Home, Office, & Cell and I am
trying to print a label in front of each one if there are data present. So I
go to my label in design mode and on the line for Phone, I keyed in:
=IIF([Phone] is null, "", "PHONE: " [Phone]). I get an invalid syntax -
operand w/o an operator. It appears to me I can't use the IIF within a
label? I would appreciate any help you may give me. Thanks, Tom

A simpler option involves no IIF at all, and uses the fact that both
the & and + operators concatenate strings, but the + operator returns
NULL if either string is NULL:

= "PHONE: " + [Phone]


John W. Vinson[MVP]