How can I format part of a multi-field control?

[Joseph Ellis]

Hello all,

I have two fields that I'd like to combine into one control in a
report:

=[phone 1 type] & ": " & [phone 1]

This produces something like:

Cell/Mobile: 2223334444

Is there any simple way to modify the above expression to produce
something like:

Cell/Mobile: (222) 333-4444

I'd like to keep this all in one control, if possible. Any
suggestions?

Thanks,
Joseph

 

[Allen Browne]

Try a Control Source of:
=[phone 1 type] & Format([phone 1], "\: \(000\) 0000000")

 

[Joseph Ellis]

Try a Control Source of:
=[phone 1 type] & Format([phone 1], "\: \(000\) 0000000")

Thanks so much, Allen.
That's exactly what I needed.