I have an unbound text box that references a combo box. The reference is a phone number and extension. The phone number comes up without a format (i.e. 3031234567 rather than (303)123-4567) even though it is formated correctly in the look up table. How can I get the formating to show on the form.
=[GSA Contact Cmb].[column](1) & " x" & [GSA Contact Cmb].[column](2)