Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric overflow
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01297788
Message ID:
01297799
Views:
18
>When I put in the mask (999) 999-9999 when it was still a string, the number (for example) 6052802087 would come out as (05) 02-87. I looked at examples of it working correctly and they were in numeric. Once I changed it to numeric, the mask worked correctly. I found that to be a little odd. I guess there was probably a better solution.

If you work with strings you should use @R for formating
If you talk about Textboxes put R in format property.
If you use TRANSFORM() function use TRANSFORM([6052802087],[@R (999) 999-9999])
The same is valid for reports, put @R (999) 999-9999 in Format property.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform