Crystal Report Format Field?

[Manny Somarriba]

Hello Good Afternoon everyone!

I have in MSAccess TEXT a field and I use it for a telephone Number. When I builded my report the telephone shows only number without format.

My Question is:

How I do format this field to shows the telephone numbers like this:

(213) 640-5678

Actually the number is showed like this 2136405678 that look pretty ugly.

[pnish]

You can use the 'Picture' function to format fields.

Make the field where you want to display the phone number a formula field and use this function in your formula, eg
Picture("2136405678","(xxx) xxx-xxxx") would display (213) 640-5678
Obviously you would replace the number I've shown with the field from your database.

Cheers

[Manny Somarriba]

Hello PNISH, how are you?

Thank you man for your response, I really apreciate your example I will try it.