Applying Input Mask after the fact (Access 2003)

If I apply an Input Mask to a field after I've already got data in it, is there a quick way to apply the mask to the pre-existing data. It appears to only work on data entered after the mask is created.

Re: Applying Input Mask after the fact (Access 2003)

Jeremy and Hans - thanks for the point in the right direction. Jeremy, specifically I'm trying to go back and apply a phone number input mask to format numbers as (555) 555-5555. I attempted to use your example and plug in that format instead, but believe I'm using incorrect syntax. Could you help. I typed (without quotes):
"Format([Phone Number],(###) ###-####)"

and am getting an error. Should I be using a different symbol (instead of #). Thanks.

Re: Applying Input Mask after the fact (Access 2003)

I think the problem you have is that you want to store the "Area Code" with the parens, so you need to put quotes around them. So your statement should look like:
<font color=blue><font face="Georgia">Format([Phone Number], "(###) ###-###)")</font color=blue></font face=georgia>
Having said that, we found that unless your numbers are specifically restricted to the North American Dialing plan (10 digits), it gets to be a real pain to try to do this kind of thing. We resorted to storing all of the format characters in the actual text string, and ran a bunch of error checking and formating code after the number was entered. Hope this helps.