I have a report where I use a text box to enter a phone number that the user
has entered on the main form. Currently, I have my verbiage with the phone
number text box right next to it. For example, "I can be reached at:" [Phone
Number]. When I do this the phone number is in the format I would expect,
(123)456-7890. I made a change to the line so that the entire line is in the
same text box. For example, ="discuss this further, I can be reached at: " &
[Investor Phone] & "." When I do this the phone number appears like so,
1234567890. Is there a way I can enter this line into the text box so that
the phone number has the parenthesis and dash , i.e. (123)456-7890?