Formatting question

Hi All, I must be overlooking something obvious, but I could reallt use some
guidance.
I can't find or figure out how to format a string in my report. The
datacolumn is just a string containing numbers like 123456789 and I need to
display it in the report as 123-45-6789 .
From the books on-line I figured I should set the format property of the
textbox to ###-##-#### but that does not seem to work. Can someone please
point me in the right direction?
Thanks
Ed###-##-#### works fine - and i get the right result.
Make sure you select the Custom option button , not the standard one.
and make sure you have a "=" in the value box.
"Ed Richard" wrote:
> Hi All, I must be overlooking something obvious, but I could reallt use some
> guidance.
> I can't find or figure out how to format a string in my report. The
> datacolumn is just a string containing numbers like 123456789 and I need to
> display it in the report as 123-45-6789 .
> From the books on-line I figured I should set the format property of the
> textbox to ###-##-#### but that does not seem to work. Can someone please
> point me in the right direction?
> Thanks
> Ed
>
>|||Ed,
You need to convert the string to a number.
Try =CDec("12345678") in the value then ###-##-### in the format
property.
Chris
Ramani wrote:
> ###-##-#### works fine - and i get the right result.
> Make sure you select the Custom option button , not the standard one.
> and make sure you have a "=" in the value box.
> "Ed Richard" wrote:
> > Hi All, I must be overlooking something obvious, but I could reallt
> > use some guidance.
> >
> > I can't find or figure out how to format a string in my report. The
> > datacolumn is just a string containing numbers like 123456789 and I
> > need to display it in the report as 123-45-6789 .
> > From the books on-line I figured I should set the format property
> > of the textbox to ###-##-#### but that does not seem to work. Can
> > someone please point me in the right direction?
> >
> > Thanks
> > Ed
> >
> >
> >|||That was it Chris, thanks very much!
Ed
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:OMk8dCXgFHA.2444@.tk2msftngp13.phx.gbl...
> Ed,
> You need to convert the string to a number.
> Try =CDec("12345678") in the value then ###-##-### in the format
> property.
> Chris
>
> Ramani wrote:
>> ###-##-#### works fine - and i get the right result.
>> Make sure you select the Custom option button , not the standard one.
>> and make sure you have a "=" in the value box.
>> "Ed Richard" wrote:
>> > Hi All, I must be overlooking something obvious, but I could reallt
>> > use some guidance.
>> >
>> > I can't find or figure out how to format a string in my report. The
>> > datacolumn is just a string containing numbers like 123456789 and I
>> > need to display it in the report as 123-45-6789 .
>> > From the books on-line I figured I should set the format property
>> > of the textbox to ###-##-#### but that does not seem to work. Can
>> > someone please point me in the right direction?
>> >
>> > Thanks
>> > Ed
>> >
>> >
>> >
>