Phone Input Mask issue

[Huddle]

I have a form that looks up the phone number from a look up table.

In the look up table I have the phone field input mask as !\(999") "000\-0000;0;_

I also have this input mask in the form field and the main table field properties where the data is stored.

It continues to store the number in the main table without the symbols.



What is going wrong?

[NTC]

its not a bug its a feature

(sorry that's a very old joke)

saving the symbols is an option....many dbs prefer the format symbols ( ) - etc not to be stored and only displayed when human eyeballs look at it....which is why it called a "mask" - what is behind the mask is the real data....

Your input mask wizard should have prompted you with this choice. Press the ... and it will reopen the wizard if you want to change.

[Huddle]

That's what is so strange. I did go through the wizard and told it to save the symbols, reason being that I have to copy the data to an excel sheet. If I copy just the numbers even if I format the cell on the excel sheet at a phone number it will not change the numbers.

[NTC]

just a guess - but remove the mask at the form level, and instead implement it at the table level - -

your table field property must be text.

let me know if that works...

[Huddle]

It didn't work. Do you happen to know why if the data is transferred with out the symbols into an excel sheet that it won't submit to formating in the excel sheet?