How do I parse a phone number?
in [Reports]
|
Prev: Charts on a Report
Next: Percentages in group totals
From: Petr Danes on 4 May 2010 19:18 I gave it in the form you would use it in VBA code. If you're using the expressions in a query, form or report, use it without the dollar sign. Also try with a semicolon instead of a comma. Pete "gagecres" <gagecres(a)discussions.microsoft.com> píše v diskusním příspěvku news:81D0CA53-29F5-4841-84E3-DAC841433E37(a)microsoft.com... >I keep getting a syntax error. > > "Petr Danes" wrote: > >> If you always have all ten digits, something like this might work: >> >> ="discuss this further, I can be reached at: " & Format$([Investor >> Phone],"(###)###-####") >> >> Pete >> >> >> "gagecres" <gagecres(a)discussions.microsoft.com> píše v diskusním >> příspěvku >> news:7B8E2324-744D-4B29-A2F9-9CCE3841DB4B(a)microsoft.com... >> >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? >> >> . >>
From: Petr Danes on 4 May 2010 19:44
And another 'brute force' method: ="discuss this further, I can be reached at: (" & left([Investor Phone];3) & ")" & mid([Investor Phone];4;3) & "-" & right([Investor Phone];4) Pete "gagecres" <gagecres(a)discussions.microsoft.com> píše v diskusním příspěvku news:81D0CA53-29F5-4841-84E3-DAC841433E37(a)microsoft.com... >I keep getting a syntax error. > > "Petr Danes" wrote: > >> If you always have all ten digits, something like this might work: >> >> ="discuss this further, I can be reached at: " & Format$([Investor >> Phone],"(###)###-####") >> >> Pete >> >> >> "gagecres" <gagecres(a)discussions.microsoft.com> píše v diskusním >> příspěvku >> news:7B8E2324-744D-4B29-A2F9-9CCE3841DB4B(a)microsoft.com... >> >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? >> >> . >> |