automaictically place decimal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to format the currancy fields so when I enter a number "169" and press tab, it automatically enters it with 2 decimal points "1.69". The field is formated to currancy. I have tried several things on the format, on enter, on exit, etc. but nothing seems to work correctly. Any sugesstions?

Thanks!
 
I would consider this a dangerous solution however, you could add code to
the After Update event of the text box to
Me.txtCurrencyField = Me.txtCurrencyField / 100

--
Duane Hookom
MS Access MVP


Scheetz LLC said:
I would like to format the currancy fields so when I enter a number "169"
Click to expand...
and press tab, it automatically enters it with 2 decimal points "1.69". The
field is formated to currancy. I have tried several things on the format,
on enter, on exit, etc. but nothing seems to work correctly. Any
sugesstions?
 
I tried this but when I enter 169 the result is $169.00. I am working with a curDebitAmout field and your reply refers to a txt field. I have many calculations based on this field, so I would need to keep it a currency type of field. I also tried =curDebitAmount/.01 with the same result. Any other suggestions?
Thanks!
 
Have you tried =curDebitAmount*.01?


Scheetz LLC said:
I tried this but when I enter 169 the result is $169.00. I am working
Click to expand...
with a curDebitAmout field and your reply refers to a txt field. I have
many calculations based on this field, so I would need to keep it a currency
type of field. I also tried =curDebitAmount/.01 with the same result. Any
other suggestions?
 
It gives me the same result $169.00.

Harvey Zimberg said:
Have you tried =curDebitAmount*.01?



with a curDebitAmout field and your reply refers to a txt field. I have
many calculations based on this field, so I would need to keep it a currency
type of field. I also tried =curDebitAmount/.01 with the same result. Any
other suggestions?
Click to expand...
 
If your code doesn't work, it is appropriate and advised to copy and paste
your exact code into a reply back to the NG.
 
Back
Top