CR9 Format Phone number 1

[kimtp]

I have a field and want to format it to (###) ###-####. My program transfer data from one .mdb to another .mdb so I can not account for the formatting in the source .mdb only the target .mdb. Sometimes the source table is blank, sometimes it has a 0 if no number is known. In any case the output is 5551234567.

Have tried many things but can not figure out how to format the output like the properties box in data reports for VB.

Any help is appreciated

Kim

 

[jkurtz]

You can use crystal's function

picture({vw_name.fieldname},"(XXX)XXX-XXXX&quot

You can also put in to an if else statement and then based on the len of your source field do a different format.

Hope this helps...

 

[synapsevampire]

Or if it's a numeric, try:

picture(totext(1234567890,0,"&quot,"(XXX)XXX-XXXX&quot

-k