How can I format a field

[Manny Somarriba]

My database is in Access and I need to format a field like this

HomePhone = " (###) ###-####

because the field print just like this whithout format

9999999999

How can I format this field and were, please



Thank in advance

[freewilly]

I assume you want to display this on a form.
There is an easier way but I can't find it.
Here's a work around

Text0 = "(" & Left(theNumber, 3) & ")" & Mid(theNumber, 4, 3) & "-" & Mid(theNumber, 7)

You may have to fiddle with the edges but this will work.
To control input do a serch for mask in the help
FW

[Bruce Fox]

How about:

MsgBox Format("0123456789", "(000) 000-0000")

will yield: (012) 345-6789


Just note; that a 6 digit number (123456) will become: (000) 012-3456

[Manny Somarriba]

Thank you for your response

The two example are correct and these work only on a form but, what about a report? I want to display on the report these fields. I can not find a way how to use it. I dont know if I have to use a formula?

[Kunchesm]

u can use a formula to do that..left , mid and right functions are availble in crystal rep also..
if the field is a number .. then first use 'totext' function to convert the number to text ..