input mask problem

[shelron]

A table and a form are both formatted with an input mask for phone number,

They are both formatted to not store the "()-", just the data,

When a user tries to edit and existing record, they get an error message saying that they must use parenthesis, (not exact message),

If you enter the parenthesis, it accepts the edit.

I have looked at my table and some of the fields show the input mask but most do not.

My question is "If I have changed the input mask storage since the creation of the table and subsequent data input, (I think I have) will the fields remain formatted as they were originally entered??"

Do I have to copy and paste the data in the table again, or run an update query to reformat the fields??

And last of all does this make any sense?


I hope so cause I have a user breathing down my neck, Ron

 

[DonQuichote]

if you translate the input, I guess you have to translate the output back as well to be consistent. It should do to set a format on the control that is used to show and enter the data

Best regards