translating number to the tenth part.

[Rani]

Hi,
first I do apologize for posting again, but I need to get over it and I
didn't yet so.

I need to find a way to represent the tenth part of a number, AKA if the
user enter 28 that number really presents the tenth part of it.
I was trying to use Me.PaymentAddKM = Me.PaymentAddKM / 100 in the
afterupdate event of the field but was unable to display anything, how do I
do that ?

 

[Wayne Morgan]

I just tried what you have listed here and it worked fine. What format do you have for the
textbox? What data type is the field that the textbox is bound to?

 

[Rani]

the field is of a numeric type.
and I don't know I've added what I submitted in the after update event and
it did nothing.
thanks

 

[Gary Miller]

Rani,

Make sure that your numeric subtype is not Integer or
LongInteger as those do not allow you to store the decimals.
You should probably use Single or Double depending on the
size of your numbers and how many decimal places you need.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Rani]

i m using ADP and the type is numeric

Rani,

Make sure that your numeric subtype is not Integer or
LongInteger as those do not allow you to store the decimals.
You should probably use Single or Double depending on the
size of your numbers and how many decimal places you need.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Wayne Morgan]

What about the formatting in the textbox. Do you have anything that would prevent a
decimal from being displayed? Does the SQL Server numeric data type include decimals, is
there a sub data type? If you unbind the textbox (remove the item in Control Source) does
it work as you would expect?