Creating Input Mask for currency in Access 2000

Daune
Daune used Ask the Experts™
on
When creating an Access database, in design view, by default requires the data entry for currency to be put in with manually using the “.”
Example:
*     When you type in the currency field “899”
by default Access formats it $899.00

What I want to do, is get rid of one key stroke and eliminate having to use a decimal to show the cents
Example
*     when “899” is keyed in it will look like this “$8.99”

I have searched and search on the net and tried many masks that seem logical but nothing will over ride the default that works

Please help!!
Your input is greatly appreciated
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
As far as I am aware teh inputMask wont do this for you.

If you set eh AfterUpdate Event to [Event Procedure] thenclick on the ... button on the right you can enter

If Me.ControlName = Int(Me.ControlName) then
   Me.ControlName = Me.ControlName / 100
End If

Cheers, Andrew
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept: TextReport
Please leave comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

nexus
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial