Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Format Expression for phone number mask
Message
 
 
To
16/04/2010 13:38:08
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01460592
Message ID:
01460597
Views:
90
This message has been marked as the solution to the initial question of the thread.
>Embarrassed to ask this but I've been away from VFP for a while. Brain freeze.
>
>I have a phone number character field in a report. Data stored as 2165551212 and I want it to print as (216)555-1212.
>
>What do I put in the format expression property in the report designer?
>
>TIA

Does

(999) 999-9999 work?

Otherwise you can use transform function for this expression.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform