Properties in report fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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