Input mask, currency?

[Guest]

What input mask would enable my user to type "12345" or "1234567890" in a
currency field and see (and save) $123.45 or $12,345,678.90 respectively?

I'm just not seeing this in help, and my experiments are requiring me to
type the period...

Thanks.

A previous suggestion, to use a currency field type, does not produce the
result above. Simply typing 1234 results in $1,234.00. I want, if possible,
$12.34.

 

[Joseph Meehan]

What input mask would enable my user to type "12345" or "1234567890"
in a currency field and see (and save) $123.45 or $12,345,678.90
respectively?

I'm just not seeing this in help, and my experiments are requiring me
to type the period...

Thanks.

A previous suggestion, to use a currency field type, does not produce
the result above. Simply typing 1234 results in $1,234.00. I want,
if possible, $12.34.

I see what you are after now.

I hope someone has a caned suggestion as I do not. But maybe I can make
a few observation and suggestions that may lead you to a solution.

First you are going to need to do something to detect the difference
between 1234 and 1234. That is $12.34 and $1,234.00 How are you going to
do this I don't know. So I am stuck on the first issue. People are people
and they are going to do this.

Is this for an application that you can be 100% certain that it will
always be entered using cents? If so we can go from there.

 

[Guest]

That's an good point Joseph. So good that I'm going to drop this. They can
type a period.

Thanks.

 

[Larry Linson]

That's an good point Joseph. So good that I'm going to drop this. They
can
type a period.

Unless you get sticky about it, and force them to, they will only have to
add the period if the amount does include cents. They won't have to type
1234.00, though, for $1234.00 -- just 1234 will do it.

Larry Linson
Microsoft Access MVP