Html.TextBoxFor, Currency

I want to be able to display currency in a TextBoxFor. I want the value to display like $1,000.00 I also want, when the user clicks inside the textbox for the $ and , to go away and just the numbers are visible for editing. I also want jquery validation to take place against the RegularExpression data annotations in the View Model.

Here is my textbox:

@Html.TextBoxFor(m => m.Info.Amount, new { Value = String.Format("{0:C}", Model.Info.Amount), onblur = "numFormatMoneyWithDecimal(this,'$',',',true)", onfocus = "RemoveFormat(this)" })

The javascript handles removing the $ and , when I enter the textbox.

Here is my RegularExpression:

[RegularExpression(@"^\$?([0-9]{1,3},([0-9]{3},)*[0-9]{3}|[0-9]+)(.[0-9][0-9])$", ErrorMessage = "Amount: only numbers followed by a decimal point followed by two numbers allowed.")]
public Nullable<decimal> Amount { get; set; }

But the problem is when I validate the ErrorMessage displays.

What is the best way to approach what I want to do? I want the $ and , stripped before I save to the database.

Re: Html.TextBoxFor, Currency

Look into a client side library to do this for you. There shouldn't be a reason to submit the form with the currency format in the textbox, that's only for display.

Look at the KendoUi Numeric box (which is only client side). It shows a formatted currency, but removes formatting when a user edits. The formatting is also NOT send to the controller, only the number
http://demos.kendoui.com/web/numerictextbox/index.html

Re: Html.TextBoxFor, Currency

I am looking for suggestions on how to approach this without purchasing additional libraries.

Re: Html.TextBoxFor, Currency

NickKA

I am looking for suggestions on how to approach this without purchasing additional libraries.

You don't have to purchase anything. KendoUI has an open source version that includes the numeric input box. As long as your company is ok with open source software then you can use it free.

In addition, there are other similar libraries that you can use, such at this plugin which is also open source
http://digitalbush.com/projects/masked-input-plugin/