Validation for a Currency textbox

[MichaeltCheong]

Who can help me on expression i want the format must be 20.00 must .00 at the back , what i should add in with my expression?

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"
ControlToValidate="TextBox1" ErrorMessage="RegularExpressionValidator"
ValidationExpression="^\s*\$?\s*\d{1,3}((,\d{3})*|\d*)(\.\d{2})?\s*$">*</asp:RegularExpressionValidator>

this expression only can check first digit cant be . only allow digit, and cant check after . must be 2digit at the back for example 20.00

[AmitGajjar]

Hi, I am not sure about the Regular expression but have couple of other solutions. 1) if you need to store decimal point in the database then that can be done through c# code as well.

decimal.Round(yourValue, 2, MidpointRounding.AwayFromZero);

2. Another way is to create javascript on the lost focus of your textbox. in the javascript function you can check for the decimal point if it is not exist then you can append that in the text box. Hope this information may lead you to some work around. Best luck

Thanks -Amit Gajjar (MinterProject)

[Yosh_]

Try it this way:

    \*

He who goes for revenge must first dig two graves.