Ed Lentz
|
| Posted: 11/22/2003, 9:27 PM |
|
Is there a way to make the entry of a phone number follow the normal format ie: (xxx)xxx-xxxx ? Not using the validation rule but to make it right even when the data entry is xxxxxxxxxx.
Thanks
Ed Lentz
|
|
|
 |
RandyL
|
| Posted: 11/23/2003, 9:39 AM |
|
ED,
Create a new project and on the solutions tab there is a CCS Example Pack. I use this project to answer all of my questions like you have stated. There is a perfect example in there that will show you what you need to do.
Randy
|
|
|
|
Ed Lentz
|
| Posted: 11/23/2003, 8:10 PM |
|
I was just being lazy I guess. I'll look there
Thanks
Ed
|
|
|
|
Karim
|
| Posted: 01/01/2004, 9:00 AM |
|
What is you have the phone number stored as xxxxxxxxxx and you would like to display it as (xxx) xxx-xxxx. Could you use the FROMAT function?
Thanks,
Karim
|
|
|
|
Karim
|
| Posted: 01/02/2004, 7:01 AM |
|
After trial and error and sweat 
You can use the format function BUT the trick is, the field has to be numeric.
not text. Then you place the format the way you want (000) 000-0000 and viola!it works.
Karim
|
|
|
|
