Input Mask question

[Dan]

I am attempting to use the input mask function for a
Currency field in a table. I am wanting any data entry in
the field to work very similar to how a calculator works,
in that I want the field to have two decimal places and to
enter any data with the two-digit decimal field included.
In other words, if someone enters "871" in the field, I
want the field to read "$8.71"; right now, no matter what
I try, I can only get it to read "$871.00".

I hope this makes sense. Any help is greatly appreciated.


-Dan.

 

[Tim Ferguson]

I am wanting any data entry in
the field to work very similar to how a calculator works,
in that I want the field to have two decimal places and to
enter any data with the two-digit decimal field included.

You can't do this with an input mask, but you can mock it up in a text box
with a bit of code in the KeyPress() event for the control. It should not
be very complex.

Bear in mind, however, that no other windows control works like this, so
you are adding a training hurdle for your users just for the sake of
showing off how quirky you can make your interface.

HTH


Tim F