Phone # in Combo Box not Formatting

[QuadSquad]

I just added a new combo box to my form to look up an account by their phone
number. It seems to be working correctly except for 1 thing - the number
shows up without the brackets ( ) and dashes - . When I look at the table it
is formatted correctly and when I look at the query it is formatted correctly
but when I pull up my form and the combo box it just shows the numbers. I
have the following input mask on my combo box - !\(999") "000\-0000;;_

I have another Access program that has the same type of combo box in it and
it is working fine and I can't see any differences between the two - they
must be there obviously or it would work but I can't tell. I am using Access
2007.

Any suggestions?
Thanks

 

[Douglas J. Steele]

I suspect that your table (and possibly query) has set the Format property
for the field in question. Instead, use the Format function in your query.

Using an input mask won't solve anything: input masks control how you input
values into a control, not how the control displays the values.