Format field as a phone number in report

[TyeReece]

I have a common access report. One of my text boxes is
="If you have questions about this report, please contact: " & [CompRptCntctFirstNm] & " " & [CompRptCntctLastNm] & " at " & [CompRptCntctPhone]
When I run it I get something like the following:
If you have questions about this report, please contact: John Smith at 1234567890

I want the [CompRptCntctPhone] to come out as formatted as a phone number. The field in the table is formatted as short text. I don't get the option to change the format in the properties box (it is blank). I guess because it is included in a larger text box. Is there an easy way to make this come out as (123) 456-7890?

 

[Joe4]

Try:

[COLOR=#333333]="If you have questions about this report, please contact: " & [CompRptCntctFirstNm] & " " & [CompRptCntctLastNm] & " at " & [/COLOR][COLOR=#ff0000]FORMAT([CompRptCntctPhone],"(@@@) @@@-@@@@")[/COLOR][COLOR=#333333][/COLOR]

 

[TyeReece]

I get an invalid syntax error (operand without an operator). But I will play with this and see. Thanks!

 

[TyeReece]

Got it to work! Thanks!

 

[welshgasman]

Got it to work! Thanks!

PMFJI,
Care to share, in case it can help others?

 

[TyeReece]

Sure. it was ="If you have questions about this report, please contact: " & [CompRptCntctFirstNm] & " " & [CompRptCntctLastNm] & " at " & Format([CompRptCntctPhone],"(@@@)-@@@-@@@@")