Properties in report fields

S

Steve

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
 
A

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.
 
Top