Make A Textbox Always Display 2 Decimal Digits.
The properties of the text box that seem relevant are set to:
Decimal places, 2
Control source, =" " & [SqM]*Forms!frmControlPanel!frmSubOptions.Form!boxCleansingCost
Input mask, blank
running sum, no
And of course the computer is set to English UK. Yes, the one that spells properly! All those stray z's. argh
Thank you for taking the time to report an issue.
What's wrong... Please write below.
If I add 0.005 I will get the correct value for this, but if I get an answer of say 100.3848 and I round it after adding the .005, my answer is wrong.
My problem would be solved if I could test the number of digits after teh decimal place.
using the right(Cinput, 1) function to test the last decimal, it returns either the 2nd, 3rd or 4th digits depending on how many decimal places there are.
The problem is that whenever you enter a number with more than 2 decimals the textbox rounds the second decimal place up or down which I don't want. I just want to drop off any decimals greater than 2.
For instance if I enter 12.225 in a textbox the value displayed is rounded up to 12.23 and I want it to display 12.22 and ignore the third decimal.
I tried an input mask and that works but is not ideal for my purpose
For example, 153.15 should become 0015315. I can only get it as far as being 15315. Is there a way I can set Properties to format this field, or is there another expression I can add to my calculation? I'm multiplying the source field by 100 to get rid of the decimal.
Any help will be appreciated as I'm stuck on this step.
How can I make the last character of the label line up with the last decimal of a currency value?
so the number would be 000009059790000
and the conversion would be 6 digits to the right of decimal and 9 digits to the left. so the output I would want is 9059.79
I was doing the following but its displaying the 0's in front and I didnt want that.so I am getting 000009059.790000
LEFT(Income, 9) + '.' + RIGHT(Income
Basically I want a control box that has a control source of
="(TRIM GIRTH= " & [Trim Girth] & ")"
Is there a way for me to make it round it to the nearest three while still in the query?
I should also mention that this is an Access 97 db that has to be totally redone at some point in a later version. It won't convert to any higher a version because there is a lot of code in it that goes back to either Access2 or Access 95.
it seems to be there because I can use datediff and my formula works but cant make it display
However, I'm trying to print a report from that form and subform. Of course, we're back to the same problem. I need to see a report AND a subreport that display the same calculations, and I seem to be right back where I started.
On my subreport, the numbers that appeared on the form are back to displaying ####### instead of a few digits with two decimal places.