Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printer format for area code & Phone #'s
Message
From
04/01/2000 18:53:23
 
 
To
04/01/2000 18:35:20
Bill Breay
Custom Business Software
Arvada, Colorado, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00312845
Message ID:
00312853
Views:
19
>Hi All,
>
>Have a basic problem. I have a table with seperate fields for area code (char. 3pos.) and phone number (Char. 7pos) with no format codes. Trying to print these fields and am not able to get () or '-' to show up on report. This is a vfp6 app.
>
>I have tried @R(999), @(999), R(999), (999) for the are code and I only get the 3 numbers such as 303.
>I have tried @R999-9999, @R###-#### and exclude the 'R' and or the '@' and only get the 7 numbers such as 9876543.
>
>What am I missing.
>
>Any help would be appreciated
> TIA
>
>Bill

You need to concatenate your fields and use a space after the R:

c3pos+c7pos and "@R (999) 999-9999"
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform