jjrr007
asked on
Format Code for phone number in VS.NET
Experts,
I am working in a VS.NET file. I wanted to ask the format code for a phone number in VS.NET?
Thanks.
I am working in a VS.NET file. I wanted to ask the format code for a phone number in VS.NET?
Thanks.
Do you mean Mask?
If mask, it could be
(999) 000-0000
(999) 000-0000
ASKER
In VS.NET properties window.
For Example, format code N0 is numbers without a decimal point. I have raised the points level.
For Example, format code N0 is numbers without a decimal point. I have raised the points level.
My guess - you can not do it without mask. Sorry.
Try this for U.S. phone numbers:
Dim n As Integer = 1234567890
Dim s As String = n.ToString("(000) 000-0000")
Bob
Dim n As Integer = 1234567890
Dim s As String = n.ToString("(000) 000-0000")
Bob
ASKER
I am using the MS Reporting Reporting Services Module in VS.NET.
The data type is Teradata. So using VB.NET code won't work like this without a whole lot of work. The options that I have (that I know of area):
Change the format box from the properties window.
Change the query in Teradata
Use Transact SQL code- directly in VS.NET Reporting Services 2003
Please advise.
The data type is Teradata. So using VB.NET code won't work like this without a whole lot of work. The options that I have (that I know of area):
Change the format box from the properties window.
Change the query in Teradata
Use Transact SQL code- directly in VS.NET Reporting Services 2003
Please advise.
Good thing that you clarified that. Good luck finding an answer :D
Bob
Bob
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.