How can I keep an expression from dropping perenthesis in phone number input mask?
Posted on 2008-11-11
I have a report using the following expression:
=IIf([HomePhone] Is Null,"",[HomePhone] & Chr(13) & Chr(10)) & [MobilePhone] & " (cell)" & IIf([SpousePhone] Is Null,"",Chr(13) & Chr(10) & [SpousePhone] & " (" & [SpouseName] & ")")
The expression does what it is supposed to do, except, I am using an input mask for the phone numbers and so the phone number is coming out without any perenthesis and dashes like it should. For example, the phone number (111) 222-3333 is coming out on the report as 1112223333 and is unacceptable. I have searched and have been unsuccessful in finding a solution. Can this be resolved?
Thanks in advance for help!