How can I keep an expression from dropping perenthesis in phone number input mask?

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!

defixer
defixerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ElrondCTCommented:
If you use a mask, the parentheses and dashes are not actually stored in the database. You need to put them in yourself when you pull the information back out. You may want to set up a function that will do that, but how the function is written depends on what database application you're using. You've posted your question in the dBase zone, but the use of brackets around the field names makes it look like you may be working in Access instead. If you can post what you're working in, I (or someone else) can help you with writing an appropriate function, if you need help.

0
defixerAuthor Commented:
Sorry about that.  When I submitted my question I was pretty sure I selected Microsoft Access.  Guess I goofed.  You are right I'm using MS Access 2003.  Thanks for the reply.
0
ElrondCTCommented:
I don't do much programming in Access. I think my answer about masks is correct for there as well as dBase, but if you need assistance with designing a function to put parentheses and dashes into each phone number, you should post a new question in the Access zone.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
defixerAuthor Commented:
Thank you.  I reposted in the Access Zone and got a fix in just a couple of days.
0
defixerAuthor Commented:
I don't know what the policy is, but he got me pointed in the right direction and when I reposted in the Access Zone where I thought I was when I posted this question I quickly got a solution.  I would like to see him awarded the points if possible because he did try and was very courtious and helpful even though he was unable to give me a resolution a resolution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.