do not want to enter the decimal point

[mictip]

I have workers who only enter currency amounts. They have asked me to make it so they only need to enter the numbers and not the decimal point. I have the tables created but no data as yet so its the best time to get the data types and general settings as needed (text vs. currency, etc.). Since creating MSAccess forms is a rarity for me, and this is a new form and two new db tables to support it, could someone assist me?

 

[Dennisk]

divide the value entered by 100

ie enter 1234

1234/100 = 12.34

 

[mictip]

where do I place the syntax and what would it look like?

 

[Dennisk]

place the code in the after update event for the control used to enter the currency value.

 

[mictip]

The users want to see the decimal point as they are entering the data; before they leave the field. If they enter 87450361045, it should show them $874,503,610.45 before they tab to the next field.

 

[mhartman]

Hello:

Look at "Input Masks". The following mask, ###.## will do what you ask. Set Format field to currency and construct the required mask for the "Input Mask" property.

Regards
Mark

 

[mictip]

Actually that doesn't work either; its what I started with. The point is, whatever is entered in the control (text box), the application should logically place the last two digits entered to the right of the decimal without the user defining where it should go by pressing the decimal point key. I would think this might need to be done programatically but I don't know? Thank you tho....it indicates to me one more way it doesn't produce the results desired; a process of elimination (like Edison and his hundreds of tests before the light came on).