Format String for SSN

I need to format a char(9) field as ###-##-####. What format string do I
use in the Format property of the Text Box?Try
= Format(Convert.ToDouble(<your field>), "###-##-####")
It is a .NET hack but it works.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"John Taylor" <jtaylor@.uab.edu> wrote in message
news:O3j#WptfEHA.3928@.TK2MSFTNGP11.phx.gbl...
> I need to format a char(9) field as ###-##-####. What format string do I
> use in the Format property of the Text Box?
>|||Thanks! If you think that's a hack, I would hate for you to see the rest of
my code! : )
John
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:%231qNXEufEHA.712@.TK2MSFTNGP09.phx.gbl...
> Try
> = Format(Convert.ToDouble(<your field>), "###-##-####")
> It is a .NET hack but it works.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "John Taylor" <jtaylor@.uab.edu> wrote in message
> news:O3j#WptfEHA.3928@.TK2MSFTNGP11.phx.gbl...
> > I need to format a char(9) field as ###-##-####. What format string do
I
> > use in the Format property of the Text Box?
> >
> >
>