By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,479 Members | 2,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,479 IT Pros & Developers. It's quick & easy.

How to display 3364751212 as (336) 475-1212 in a report?

P: n/a
MLH
In the Format property setting field
in the format properties window of
A97 - what is the correct syntax to
convert "3364751212" to

(336) 475-1212

for display purposes only in a report?
Jul 27 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Assuming your field name is PhoneNum, I would enter the following in a
text box on the report:

= "(" & Left(PhoneNum, 3) & ") " & mid(PhoneNum, 4, 3) & "-" &
right(PhoneNum, 4)

MLH wrote:
In the Format property setting field
in the format properties window of
A97 - what is the correct syntax to
convert "3364751212" to

(336) 475-1212

for display purposes only in a report?
Jul 27 '06 #2

P: n/a
On Thu, 27 Jul 2006 12:26:52 -0400, MLH wrote:
In the Format property setting field
in the format properties window of
A97 - what is the correct syntax to
convert "3364751212" to

(336) 475-1212

for display purposes only in a report?
Set the Format of a bound control to:
(@@@) @@@-@@@@

Use in an unbound control.
Set it's control source to:
=Format([PhoneField],"(@@@) @@@-@@@@")
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jul 27 '06 #3

P: n/a
MLH
Did the trick. Many thanks fredg.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Jul 27 '06 #4

P: n/a
MLH
Fred - am curious as to why
(@@@) @@@-@@@@
works

and
"("***") "***"-"****
does not?

I'm speaking now of their use in a query. IE,
click in the cell of QBE grid, open the properties
window for the query object being defined, click
in the Format property field, press F1. The A97
help implies the latter is a valid format property
string setting.
Aug 16 '06 #5

P: n/a
On Wed, 16 Aug 2006 15:06:50 -0400, MLH wrote:
Fred - am curious as to why
(@@@) @@@-@@@@
works

and
"("***") "***"-"****
does not?

I'm speaking now of their use in a query. IE,
click in the cell of QBE grid, open the properties
window for the query object being defined, click
in the Format property field, press F1. The A97
help implies the latter is a valid format property
string setting.
You didn't dig deep enough.
After you click F1 and the Format Property help displays, click on the
Text and Memo Data Types hyperlink.
Down in the Example section .....
Setting Data Display
@@@-@@-@@@@ 465043799 465-04-3799
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 16 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.