phone number formatting

D

Daniel

Hello

I store phone numbers in my table in numeric format (without parenthesis,...
- ie 5555555555). In my forms I use an input mask to make it more user
friendly (555) 555-555. However, now I'm trying to put together a simple
report and would like to know if there is a simple way to display the phone
number per the form (555) 555-5555 or if I have to use left() and right()...
to extract the info into the appropriate position? Am I missing something
really obvious (feels like I must be)?

Thank you,

Daniel P
 
O

Ofer Cohen

You can use the Format in the ControlSurce of the text box

=Format([FieldName],"(@@@) @@@-@@@@")
 
D

Daniel

Thank you for the quick reply!

Daniel P





Ofer Cohen said:
You can use the Format in the ControlSurce of the text box

=Format([FieldName],"(@@@) @@@-@@@@")
--
Good Luck
BS"D


Daniel said:
Hello

I store phone numbers in my table in numeric format (without parenthesis,...
- ie 5555555555). In my forms I use an input mask to make it more user
friendly (555) 555-555. However, now I'm trying to put together a simple
report and would like to know if there is a simple way to display the phone
number per the form (555) 555-5555 or if I have to use left() and right()...
to extract the info into the appropriate position? Am I missing something
really obvious (feels like I must be)?

Thank you,

Daniel P
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top