Help! Please

[Art Vandaley]

Hi.

1.5*5.5 = 8.25

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


Detail---------------------------------------------------------------------------

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
---------------------------------------------------------------------------------


How can I fix it?

Many thanks for any help...

 

[Jerry Whittle]

That is strange.

Possibly you have found a bug which should be reported to MS. Unfortunately
I don't have a computer with A07 near me right now.

Or there's something else going on. Have you checked the formatting
properties for that text box? Possibly what you are seeing in the form or
table isn't actually what's stored there.

You can't have calculations like 1.5*5.5 in tables (unless MS really messed
up A07). Do you mean queries?

 

[Art Vandaley]

No calculation in table. Form is bounded to this table and textbox2 value
goes to that table.

I checked the formatting of textbox. It is weird. Some more help please.

That is strange.

Possibly you have found a bug which should be reported to MS.
Unfortunately
I don't have a computer with A07 near me right now.

Or there's something else going on. Have you checked the formatting
properties for that text box? Possibly what you are seeing in the form or
table isn't actually what's stored there.

You can't have calculations like 1.5*5.5 in tables (unless MS really
messed
up A07). Do you mean queries?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hi.

1.5*5.5 = 8.25

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


Detail---------------------------------------------------------------------------

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
---------------------------------------------------------------------------------

How can I fix it?

Many thanks for any help...

 

[KARL DEWEY]

Still not clear where everything is comming and going.
Where is the 1.5? Where is the 5.5? Where is the resulting 8.20?
--
KARL DEWEY
Build a little - Test a little

No calculation in table. Form is bounded to this table and textbox2 value
goes to that table.

I checked the formatting of textbox. It is weird. Some more help please.

That is strange.

Possibly you have found a bug which should be reported to MS.
Unfortunately
I don't have a computer with A07 near me right now.

Or there's something else going on. Have you checked the formatting
properties for that text box? Possibly what you are seeing in the form or
table isn't actually what's stored there.

You can't have calculations like 1.5*5.5 in tables (unless MS really
messed
up A07). Do you mean queries?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hi.

1.5*5.5 = 8.25

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


Detail---------------------------------------------------------------------------

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
---------------------------------------------------------------------------------

How can I fix it?

Many thanks for any help...

 

[Maurice]

Hi Art,

I tried your calculations in Acc 2007. On a form with just two regular
textboxes

output: 1.5 * 5.5 = 8.25

Also tried Immediate Window in VBA

1.5*5.5
8.25

So my guess is that you've got a certain setting wrong but because we don't
have any more info i'm just guessing...