If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I parse a phone number?
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? |
Thread Tools | |
Display Modes | |
|
|