T
Top Gun
I have a textbox that displays money amounts as 999999999.99. The user would
like the keyer to either type in a decimal point or, if one is NOT supplied,
imply one. Furthermore, when the textbox is populated from the database
using a money datatype, it is four decimals to the right, which must be
formatted to two.
So, as far as keying, if a user (as an extreme) types in the following, they
should diplay as:
1 display as 0.01
..1 display as 1.10
100 display as 1.00
1.00 display as 1.00
1.0000 display as 1.00
etc.
I'm sure this can be done using Regex, but it seems a little tricky.
like the keyer to either type in a decimal point or, if one is NOT supplied,
imply one. Furthermore, when the textbox is populated from the database
using a money datatype, it is four decimals to the right, which must be
formatted to two.
So, as far as keying, if a user (as an extreme) types in the following, they
should diplay as:
1 display as 0.01
..1 display as 1.10
100 display as 1.00
1.00 display as 1.00
1.0000 display as 1.00
etc.
I'm sure this can be done using Regex, but it seems a little tricky.