Input mask, currency?

[Ricter]

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.

 

[Ricter]

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