 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Help! Please
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... 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?  SignatureJerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > Hi. > [quoted text clipped - 15 lines] > > Many thanks for any help... 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. > [quoted text clipped - 31 lines] >> >> Many thanks for any help... > 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. Tables don't do calculations, they only store data and information. SignatureJoseph Meehan Dia 's Muire duit 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? SignatureKARL DEWEY Build a little - Test a little > No calculation in table. Form is bounded to this table and textbox2 value > goes to that table. [quoted text clipped - 36 lines] > >> > >> Many thanks for any help... 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... SignatureMaurice Ausum > Hi. > [quoted text clipped - 15 lines] > > Many thanks for any help... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.