Properties in report fields

[Guest]

How can you set the properties in a report field to print a phone number with
an input mask if there is one or to print "none" if there is no phone number

 

[Allen Browne]

Try setting the ControlSource of the text box to something like this:
=IIf([phone] Is Null, "none", Format([phone] "\(000\)...

You will also need to change the Name of the text box, as Access gets
confused if the control has the same name a field but is bound to something
else.