From: Petr Danes on
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
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?
>>
>> .
>>

First  |  Prev  | 
Pages: 1 2
Prev: Charts on a Report
Next: Percentages in group totals