Numeric or currency field format

acdsky · July 14th, 2004, 07:57 AM

Hi

I have got an asp form with a textbox that accepts numeric caracters. At the moment have got a piece of Java that checks that the data is numeric before submitting to the SQL database. Now they want to change it to the following format e.g 1,000,000.00 How do I force the user on client side to input the data like this? I was thinking of a text box that format the value as the user type..Almost like an ATM machine. e.g 0,00.00 for default and as the user types it fills the zeros. Or a way to format and check the data before submission.

I hope this makes sense. Any ideas appreciated.

Regards
Marnus

happygv · July 14th, 2004, 08:14 AM

Lucky enough to get that so soon;)

Code:

<html>
<head>
<script language="javascript">
function CommaFormatted(amount)
{
    var delimiter = ","; // replace comma if desired
    var a = amount.split('.',2)
    var d = a[1];
    var i = parseInt(a[0]);
    if(isNaN(i)) { return ''; }
    var minus = '';
    if(i < 0) { minus = '-'; }
    i = Math.abs(i);
    var n = new String(i);
    var a = [];
    while(n.length > 3)
    {
        var nn = n.substr(n.length-3);
        a.unshift(nn);
        n = n.substr(0,n.length-3);
    }
    if(n.length > 0) { a.unshift(n); }
    n = a.join(delimiter);
    if(d.length < 1) { amount = n; }
    else { amount = n + '.' + d; }
    amount = minus + amount;
    return amount;
}
// end of function CommaFormatted()
</script>

</head>
<body>
Enter Number and tab out: <input type="text" name = "Num" value="" onblur="Javascript:FormattedNum.value=CommaFormatted(this.value);">
Formatted Number : <input type="text" name = "FormattedNum" value="">
</body>
</html>

Cheers!

_________________________
- Vijay G
Strive for Perfection

acdsky · July 14th, 2004, 08:22 AM

Thanks! Will give it a shot.

Marnus