Please help

A

Art Vandaley

Hi.

1.5*5.5 = 8.25

In Access forms and tables 1.5*5.5 = 8.20 (which is not correct)

How can I fix it?

Many thanks for any help...
 
R

RBear3

It equals 8.25 in my forms as well.

What is in your control on your form? Are you multiplying a field by a
field, or are you asking the user to enter one or both values into unbound
controls?

If using data from a table, what type of field is it?

More details please.
 
A

Art Vandaley

It is a textbox. I get value from textbox1 and put the result into textbox2.
I use below code for multiplying:

textbox2.Value = Nz([textbox1]) * 1.5

If textbox1 has a value like 5.5 then I see 8.20 in textbox2 instead of 8.25

Thanks for your help
 
Top