Tuesday, March 13, 2012

Simple formatting question...

How do I get a number like "131" to appear in a currency format like "$131.00" in a TextBox control?

I know it's simple but I cannot find how to do this in any reference manual.

TIA...add a maskedEdite control and set the format you want
to add this rigth clik toolbox and choose customise toolbox you will find
this control

"The Eeediot" wrote:

> How do I get a number like "131" to appear in a currency format like "$131.00" in a TextBox control?
> I know it's simple but I cannot find how to do this in any reference manual.
> TIA...
Hmmm.

That might work if I were using Visual Studio.NET but I'm using Web Matrix.

I ended up improvising by using:

txtTotalSalesYTD.Text = "$" & String.Format("{0:F2}",
CDbl(dreader("TotalSales")))

"sara" <sara@.discussions.microsoft.com> wrote in message
news:134AA838-464B-4077-BCF4-80AC96D0E979@.microsoft.com...
> add a maskedEdite control and set the format you want
> to add this rigth clik toolbox and choose customise toolbox you will find
> this control
> "The Eeediot" wrote:
> > How do I get a number like "131" to appear in a currency format like
"$131.00" in a TextBox control?
> > I know it's simple but I cannot find how to do this in any reference
manual.
> > TIA...
Tostring takes standard formatting, so slightly simpler:
cdbl(dreader("TotalSales")).tostring("c")

Bill

"The Eeediot" wrote:

> Hmmm.
> That might work if I were using Visual Studio.NET but I'm using Web Matrix.
> I ended up improvising by using:
> txtTotalSalesYTD.Text = "$" & String.Format("{0:F2}",
> CDbl(dreader("TotalSales")))
> "sara" <sara@.discussions.microsoft.com> wrote in message
> news:134AA838-464B-4077-BCF4-80AC96D0E979@.microsoft.com...
> > add a maskedEdite control and set the format you want
> > to add this rigth clik toolbox and choose customise toolbox you will find
> > this control
> > "The Eeediot" wrote:
> > > How do I get a number like "131" to appear in a currency format like
> "$131.00" in a TextBox control?
> > > > I know it's simple but I cannot find how to do this in any reference
> manual.
> > > > TIA...
>

0 comments:

Post a Comment