how can i display cents

  • Thread starter Thread starter Rani
  • Start date Start date
R

Rani

hi guys
I have a field in which the user enters a numeric value representing
cents.AKA if the user enters 25 it is really 0.25 as I am passing the field
value I am passing inaccurate value.

any idea ?

thanks
 
that is the code I'm using in the afterupdate event of that field and am not
getting anything.
Me!PaymentAddKM = (PaymentAddKM / 100)
 
you need the me before the field name the second time
aswell:

Me.PaymentAddKM = Me.PaymentAddKM / 100

Personally I think this may get confusing people see
current records have the cents as .25 and enter this in
another record so you end up with .0025 cents. I would
either have the field as one value so they type 23.25 in
one field or if you really want cents seperate, divide
when you need to calculate something not at the data
entry point.

Just a thought.
 
Back
Top