phone number formatting

[Guest]

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

 

[Guest]

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

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

 

[Guest]

Thank you for the quick reply!

Daniel P

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

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

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