CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> Archive -> GotoCode Archive

 Phone number and Zip Code format

Print topic Send  topic

Author Message
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.


Ed Lentz
Posted: 11/23/2003, 9:39 AM

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.

Ed Lentz
Posted: 11/23/2003, 8:10 PM

I was just being lazy I guess. I'll look there


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?

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.



These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.