I use the following expression in a text box on a Report to trim off extra spaces and put in the words "Ext." if there is a phone extension and "Fax" is there is a fax number:

=Trim([FirstName] & " " & [LastName]) & Chr(13) & Chr(10) & IIf(IsNull([Title]),"",[Title] & Chr(13) & Chr(10)) & [Contacts_Agency] & IIf(IsNull([Contacts_DivDept]),"",", " & [Contacts_DivDept]) & Chr(13) & Chr(10) & [address] & Chr(13) & Chr(10) & IIf(IsNull([Address2]),"",[Address2] & Chr(13) & Chr(10)) & [city] & ", " & [state] & " " & [Zip] & Chr(13) & Chr(10) & "Phone: " & [phone] & " " & IIf(IsNull([Ext]),"","Ext: " & [Ext]) & Chr(13) & Chr(10) & IIf(IsNull([Fax]),"","Fax: " & [Fax] & Chr(13) & Chr(10)) & [email]


My problem is that the input mask (done at the table level) doesn't hold in this expression. If I add the phone field separately it appears just fine. Does anyone know what approach I can use to my input mask to stay on the phone number and fax fields?