I had a similar problem with telephone numbers - when printed they would appear without brackets and with no spaces as 6045385830 instead of (604) 538-5830.
I ran ounto the following solution - I think the source link is at the bottom of the solution. Hope this helps.
On the Field Explorer:
Right Click 'Formula Fields'
Choose 'New'
Create a new formula with this
If the value you are passing is a number use ToText:
Picture(ToText({ORGANIZATION_VW.ORGA_CONTACT_PHONE}),"(xxx)xxx-xxxx")
Save it and then use it. If you see commas and decimals then you need to go to 'File' and then 'Options' then 'Fields', Choose Numbers, then Customize then take out the thousands and make decimal 1 (get it to a number without any commas or decimals) .
It should look right now.
http://www.xtremevbtalk.com/showthread.php?t=142156
IP Logged
