Text in an expression

[Propoflady]

Ok I have a report that lists different contact numbers, phone, fax,
email. When I print the report I need a label for example Phone:
(xxx) xxx-xxxx but if there is no phone number then I need the next one
printed example Fax: (xxx) xxx-xxxx. Each record could have all or
only one or two of the numbers, I dont' want the labels to print unless
there is a number, how can I do this?

thanks

[fredg]

On 20 Jun 2006 11:57:07 -0700, Propoflady wrote:

Ok I have a report that lists different contact numbers, phone, fax,
email. When I print the report I need a label for example Phone:
(xxx) xxx-xxxx but if there is no phone number then I need the next one
printed example Fax: (xxx) xxx-xxxx. Each record could have all or
only one or two of the numbers, I dont' want the labels to print unless
there is a number, how can I do this?

thanks

Your use of the term 'Label' is ambiguous in Access.
A label may be a control on a report or a printable mailing label as
well as a text identifier.

I'll guess you mean a text identifier on a report.
If I understand you correctly, you wish to print either

Phone: [phone] Fax: [phone]
or if there is no Phone #
Fax: [phone]

Use an unbound Text Control.
set it's control source to:
=IIf(IsNull([Phone]),"Fax: " & [Fax#], "Phone: " & [Phone#] & " " &
"Fax" " & [Fax#])

If you think there may be a Phone# but no Fax#, then you can use:
=IIf(IsNull([Phone]),"Fax: " & [Fax#], "Phone: " & [Phone#] & (" "
& "Fax" " + [Fax#]))
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail