unmask phone numbers

[madEG]

Hello,

I had a rather odd request that I can't quite figure out how to fulfill...

A user wants on a report to not have the phone numbers masked such as:

(123) 456-7890 format,

but all out as a string like 1234567890... (weird, but whatever)

It is being stored via the mask in the table as the former. Is there a way to change the report's control mask to revert the phone info back to the unformatted way?

Short of string slicing that is...

Thanks,
-Matt G.

 

[madEG]

ahh, nevermind.

='9' & Mid([Office Fax],3,2) & Mid([Office Fax],3,7) & Right([Office Fax],4)

...just was easier in the end.