Printable View
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.
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
Hello PNISH, how are you?
Thank you man for your response, I really apreciate your example I will try it.