automaictically place decimal

[Scheetz LLC]

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!

 

[Duane Hookom]

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

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?

 

[Scheetz LLC]

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!

 

[Harvey Zimberg]

Have you tried =curDebitAmount*.01?

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?

 

[Scheetz LLC]

It gives me the same result $169.00.

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?

 

[Tim Ferguson]

It gives me the same result $169.00.

Stop using a Currency field: use a Long Integer and call it Cents.

Makes sense to me...


Tim F

 

[Duane Hookom]

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.